sample179.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 18 行

/* 文件名称: 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)
)