- 科技
- slqserver笔记4
文章目录
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
='高等数学')
Processed:
0.020, SQL:
8
