the correct on should be SELECT field1 FROM ONE WHERE NOT EXIST ( SELECT *FROM TWO) GROUP BY FIELD1 HAVING COUNT (FIELD1)>3 -->在B表为空的前提下,找出A表中FIELD1的值重复超过3行的值或 SELECT * FROM ONE WHERE NOT EXIST ( SELECT FIELD1 FROM TWO GROUP BY FIELD1 HAVING COUNT (FIELD1)>3 ) -->如果B表中有某些FIELD1的值重复超过3行,就显示A表中所有的行.
WHERE NOT EXIST (
SELECT *FROM TWO)
GROUP BY FIELD1
HAVING COUNT (FIELD1)>3
-->在B表为空的前提下,找出A表中FIELD1的值重复超过3行的值或
SELECT * FROM ONE
WHERE NOT EXIST (
SELECT FIELD1 FROM TWO
GROUP BY FIELD1
HAVING COUNT (FIELD1)>3 )
-->如果B表中有某些FIELD1的值重复超过3行,就显示A表中所有的行.