SELECT C1,C2 FROM T1 --WHERE C1 NOT IN (SELECT D1 FROM T2 WHERE D2 = '112') LEFT JOIN (SELECT D1 FROM T2 WHERE D2 = '112') T2 ON C1=D1 WHERE D1 IS NULL
select a.c1,a.c2 from t1 a left join t2 b on a.c1=b.d1 where b.d2<>'112'
你的例子上不就是这样的么? 如果要通用,那得写存储过程,传入一个变量进来,设为@d2,然后:select a.c1,a.c2 from t1 a left join t2 b on a.c1=b.d1 where b.d2 <>@d2
SELECT C1,C2 FROM T1 --WHERE C1 NOT IN (SELECT D1 FROM T2 WHERE D2 = '112')
LEFT JOIN (SELECT D1 FROM T2 WHERE D2 = '112') T2 ON C1=D1
WHERE D1 IS NULL
如果要通用,那得写存储过程,传入一个变量进来,设为@d2,然后:select a.c1,a.c2 from t1 a left join t2 b on a.c1=b.d1 where b.d2 <>@d2