求教一个SQL语句,特简单
表t1
ypdm ypmc ggxh
001 1
002 1
002 2
003 1
还有一个t2表存着一些ypdm,ggxh等等
我想要找出,t1中ypdm和ggxh不在t2表里的数据,请问怎么写
我自己写的
SELECT ypdm,
ypmc,
ggxh
FROM t1
WHERE t1.ypdm,t1.ggxh NOT IN (SELECT ypdm,ggxh FROM t2)
这样报错,
又写了个
SELECT ypdm,
ypmc,
ggxh
FROM t1
WHERE t1.ypdm NOT IN (SELECT ypdm FROM t2)
and t1.ggxh NOT IN (SELECT ggxh FROM t2)
也不对
请问应该怎么写?
谢谢
[解决办法]
SELECT ypdm,
ypmc,
ggxh
FROM t1
WHERE not exists(select 1 from t2 where t1.ypdm = t2.ypdm and t1.ggxh = t2.ggxh)