注册 登录
编程论坛 SQL Server论坛

[求助]exists的用法

windwind 发布于 2007-03-25 10:02, 700 次点击
请高手能详细讲一下exists的用法,我对exists的用法还很模糊,谢谢!
USE pubs
GO
SELECT DISTINCT pub_name
FROM publishers
WHERE EXISTS
(SELECT *
FROM titles
WHERE pub_id = publishers.pub_id
AND type = 'business')
上面例子的具体含义.如果我把它改成
SELECT DISTINCT pub_name
FROM publishers
WHERE EXISTS
(SELECT *
FROM titles)
又有何含义呢?

1 回复
#2
棉花糖ONE2007-03-25 10:32

记住一点就好,用exists的时候,括号中用到的表和外面的表要有个关联,就如pub_id = publishers.pub_id

1