34,590
社区成员
发帖
与我相关
我的任务
分享
declare @publisher varchar(30)
set @publisher='电子工业出版社'
select book_name,reader_name,reader_type
from READER,Book
where READER.Borrow_id=Borrow.Borrow_id
and Book.Book_id=Borrow.Borrow_id
and publisher=@publisher
这条语句没有查询到Borrow表 所以无法绑定Borrow.Borrow_id
declare @publisher varchar(30)
set @publisher='电子工业出版社'
select book_name,reader_name,reader_type
from Borrow
inner join READER
on READER.Borrow_id=Borrow.Borrow_id
inner join Book
on Book.Book_id=Borrow.Borrow_id
where publisher=@publisher
create PROCEDURE p3
@publisher varchar(30)
as
select book_name,reader_name,reader_type
from Borrow
inner join READER
on READER.Borrow_id=Borrow.Borrow_id
inner join Book
on Book.Book_id=Borrow.Borrow_id
where publisher=@publisher