vf中sql语句where not和where not in什么区别
not是将判断结果取反，not in 是将判断是否包含的结果取反，not in 更具体点
怎么用用sql语句中的not exists来写语句？
USE pubs
GO
SELECT DISTINCT pub_name
FROM publishers
WHERE EXISTS
(SELECT *
FROM titles
WHERE pub_id = publishers.pub_id
AND type = 'business')
GO
-- Or, using the IN clause:
USE pubs
GO
SELECT distinct pub_name
FROM publishers
WHERE pub_id IN
(SELECT pub_id
FROM titles
WHERE type = 'business')
GO
下面是任一查询的结果集：
pub_name
----------------------------------------
Algodata Infosystems
New Moon Books