slqserver笔记4

最新推荐文章于 2024-10-05 14:16:38 发布

叫我柒月

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量180

点赞数

分类专栏： sql server 文章标签： sql

本文链接：https://blog.csdn.net/xiaobai_july/article/details/108960591

版权

sql server 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

文章目录

- 1.多表连接

1.多表连接

在这里插入图片描述

select name,book_id from Reader r join borrow b on r.reader_ID=b.reader_ID
where borrowdate = '2005-1-20'

在这里插入图片描述

select book_id,borrowdate from Borrow where reader_ID=(select reader_ID from Reader where name ='王旭')--第一种方法
select book_id,borrowdate from Borrow b join Reader r on b.reader_ID=r.reader_ID where name='王旭'--第二种方法

在这里插入图片描述

select book.name,reader.name from Reader join Borrow on reader.reader_ID=borrow.reader_ID  join book on book.book_ID=borrow.book_ID

在这里插入图片描述

select name from Book join Borrow on book.book_ID=borrow.book_ID where reader_ID=(select reader_ID from Reader where name='王旭')
select name from Reader r join Borrow b on r.reader_ID=b.reader_ID where b.book_ID in(select book_ID from book where price>=20 and price<=40)
select reader.name 
FROM Reader JOIN Borrow 
ON Reader.Reader_id = Borrow.Reader_id  
JOIN Book ON Borrow.book_ID=Book.book_ID 
select Borrowdate from borrow where 
reader_id=(select reader_id from reader where name='胡晓丽' ) and book_id=(select book_id from book where 
name='高等数学')