ylbtech-SQL Server:SQL Server-子查询(嵌套子查询)和子查询(相关子查询) |
SQL Server 子查询(嵌套子查询)和子查询(相关子查询)。
1,ylb:1,子查询(嵌套子查询)返回顶部 |
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
1,ylb:2,子查询(相关子查询)返回顶部 |
-- ============================================= -- ylb:本案例探讨的是:“相关子查询” -- 11:25 2011/12/9 -- ============================================= use pubs go --一、相关子查询 --P1:查询出版社和商店在同一个州的商店名称? go select * from publishers select * from stores go --结论 select stor_name from stores s where state in(select state from publishers where state=s.state) go --P2:查询出版社和作者在同一个的作者姓名? select * from publishers select * from authors go --结论 select * from authors a where state in (select state from publishers where state=a.state)