select * from TABLE_TJB,TABLE_BUY where TABLE_TJB.user_id=TABLE_BUY.BUY_USER_KEY
AND TABLE_TJB.yf=TABLE_BUY.BUY_TIMES
返回的是 TABLE_TJB中满足条件的数据我现在想查出TABLE_TJB 中不满足这个条件的数据集,
SQL语句该如何写啊
AND TABLE_TJB.yf=TABLE_BUY.BUY_TIMES
返回的是 TABLE_TJB中满足条件的数据我现在想查出TABLE_TJB 中不满足这个条件的数据集,
SQL语句该如何写啊
select *from TABLE_TJB where ID not in( select TABLE_TJB.ID from TABLE_TJB,TABLE_BUY where TABLE_TJB.user_id=TABLE_BUY.BUY_USER_KEY
AND TABLE_TJB.yf=TABLE_BUY.BUY_TIMES )
有主键吗? 有主键ID 可以用上面的语句
AND TABLE_TJB.yf<>TABLE_BUY.BUY_TIMES
AND TABLE_TJB.yf=TABLE_BUY.BUY_TIMES )
WHERE A.yf<>B.BUY_TIMES
select *from TABLE_TJB where 主键字段 not in( select TABLE_TJB.ID from TABLE_TJB,TABLE_BUY where TABLE_TJB.user_id=TABLE_BUY.BUY_USER_KEY
AND TABLE_TJB.yf=TABLE_BUY.BUY_TIMES )