--查询借走书籍号为A0001这本书所有借阅读者的基本信息
select readers.* from Readers,Borrow
where (Readers.R_ID=Borrow.R_ID) and Borrow.B_ID='A0001'
SQL Server创建一个涉及2个表的查询操作
最新推荐文章于 2024-08-12 13:17:14 发布
--查询借走书籍号为A0001这本书所有借阅读者的基本信息
select readers.* from Readers,Borrow
where (Readers.R_ID=Borrow.R_ID) and Borrow.B_ID='A0001'