sample179.sql

T-SQL示例大全

/* 文件名称: Sample179.sql */
USE pubs

SELECT ST.stor_id,
       ST.stor_name,
       ST.city,
       ST.state
  FROM stores ST
  WHERE NOT EXISTS
	(SELECT * FROM titles T1
	   WHERE NOT EXISTS
		(SELECT * 
                   FROM titles T2
                        INNER JOIN sales SA
                        ON T2.title_id = SA.title_id
                   WHERE T2.title_id = T1.title_id AND
                         ST.stor_id = SA.stor_id)
)