SELECT *FROM ONE
WHERE NOT EXIST (
SELECT *FROM TWO)
GROUP BY FIELD1
HAVING COUNT (FIELD1)>3 ---> Syntax Error
WHERE NOT EXIST (
SELECT *FROM TWO)
GROUP BY FIELD1
HAVING COUNT (FIELD1)>3 ---> Syntax Error
调试欢乐多
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表中所有的行.