数据库查询尚未归还的借书记录(查询借书但未归还的读者的编号、姓名及所借图书编号、
use Library
go
select Borrow.Rno,Reader.Rname,Book.Btitle,Borrow.BorrowDate,Borrow.ReturnDate
from Borrow, Reader,Book
where Reader.Rno = Borrow.Rno and Book.Bno = Borrow.Bno
and Borrow.ReturnDate is NULL;
-- and Borrow.ReturnDate < getdate(); --从归还日期开.
原创
2021-04-07 10:40:54 ·
11791 阅读 ·
1 评论