fatgy · February 3, 2014 13:33
diff --git a/find-not-match.sql b/find-not-match.sql
 SELECT p.extracted_code
 FROM  (
  select extracted_code
  from policy
  group by extracted_code
 ) AS p
 LEFT OUTER JOIN (
  SELECT code_cleaned
  FROM `commission`
  group by code_cleaned
 ) AS s
 ON s.code_cleaned = p.extracted_code
 WHERE  s.code_cleaned IS NULL;
	SELECT p.extracted_code
	FROM (
	select extracted_code
	from policy
	group by extracted_code
	) AS p
	LEFT OUTER JOIN (
	SELECT code_cleaned
	FROM `commission`
	group by code_cleaned
	) AS s
	ON s.code_cleaned = p.extracted_code
	WHERE s.code_cleaned IS NULL;