sample172.sql

来自「T-SQL示例大全」· SQL 代码 · 共 10 行

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

SELECT au_lname, au_fname FROM authors 
   WHERE au_id IN
         (SELECT au_id FROM titleauthor 
              WHERE title_id IN
                   (SELECT title_id FROM titles WHERE type = 'popular_comp'))