5、not in的使用.sql

本代码简单明了

--功能实现：查找所有曾出版过商业书籍的出版商的名称

USE pubs
go

SELECT pub_name,pub_id
FROM publishers
WHERE pub_id NOT IN
   (SELECT pub_id
   FROM titles
   WHERE type = 'business')



select a.pub_name,a.pub_id,b.pub_id,b.type
from publishers as a
inner join titles as b
on a.pub_id <> b.pub_id and type = 'business'