有如下两个表 tb1 col col1 abc 111 cde 111 qaz 222 tgb 222
tb2 col2 col3 abc 111 qaz 222
我怎么查询TB1表哪些数据在TB2表是没有的select * from TB1 where not exsits (select * from TB2) SQL code: select * from tb1 where not exsits (select * from tb2)
SQL code: select * from tb1 where not exists (select * from tb2)
可能描述错了，这两个表应该是这样的 如下: tb1 guid col col1 dadf abc 111 1erw cde 111 21qe qaz 222 qweq tgb 222
tb2 guid col2 col3 w5wr abc 111 w34f qaz 222 SQL code: select * from tb1 where not exists (select * from tb2 where tb1.col=tb2.col2 and tb1.col1=tb2.col3)
SQL code: declare @t varchar(5000) set @t='' select @t=@t+',[取消分析-'+quXiaoFenXi+']=sum(case when [quXiaoFenXi]='+quotename([quXiaoFenXi],'''')+' then shangPinZongShu else 0 end)' from tb_gyyD ......
