sql 语句查询出来的值 在a表里面不错在。select * from b where b.code not in (select code from a)问题: 如果3个字段(code,linecode,name)才能判断在a 表里面不存在该怎么写???
select * from b where (select code,linecode,name NOT IN (SELECT code,linecode,name FROM b))
select * from b where (select code,linecode,name NOT IN (SELECT code,linecode,name FROM b))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货