create procedure SelectLostBook
@BookID CHAR(15),
@ReaderID CHAR(11)
AS
select b.ISBN,b.BookName,b.Author,b.PulishDate,b.State,b.Pulisher,b.BookTypeID,
a.ReaderName,a.Sex,a.ReaderType,a.Department,a.Class,a.Email,c.BookID,c.ReaderID from dbo.LostInfo as
c inner join from dbo.ReaderInfo as a on ReaderID=@ReaderID INNER JOIN from dbo.BookInfo AS b
on BookID=@BookID
@BookID CHAR(15),
@ReaderID CHAR(11)
AS
select b.ISBN,b.BookName,b.Author,b.PulishDate,b.State,b.Pulisher,b.BookTypeID,
a.ReaderName,a.Sex,a.ReaderType,a.Department,a.Class,a.Email,c.BookID,c.ReaderID from dbo.LostInfo as
c inner join from dbo.ReaderInfo as a on ReaderID=@ReaderID INNER JOIN from dbo.BookInfo AS b
on BookID=@BookID
@BookID CHAR(15),
@ReaderID CHAR(11)
AS
select b.ISBN,b.BookName,b.Author,b.PulishDate,b.State,b.Pulisher,b.BookTypeID,
a.ReaderName,a.Sex,a.ReaderType,a.Department,a.Class,a.Email,c.BookID,c.ReaderID from dbo.LostInfo as
c inner join dbo.ReaderInfo as a on ReaderID=@ReaderID INNER JOIN dbo.BookInfo AS b
on BookID=@BookID
消息 209,级别 16,状态 1,过程 SelectLostBook,第 7 行
列名 'ReaderID' 不明确。
消息 209,级别 16,状态 1,过程 SelectLostBook,第 8 行
列名 'BookID' 不明确。
@BookID CHAR(15),
@ReaderID CHAR(11)
AS
select b.ISBN
,b.BookName
,b.Author
,b.PulishDate
,b.State
,b.Pulisher
,b.BookTypeID
, a.ReaderName
,a.Sex
,a.ReaderType
,a.Department
,a.Class
,a.Email
,c.BookID
,c.ReaderID
from dbo.LostInfo as c
inner join
dbo.ReaderInfo as a on ReaderID=@ReaderID
INNER JOIN
dbo.BookInfo AS b on BookID=@BookID
b.Author,b.PulishDate,b.State,b.Pulisher,
b.BookTypeID,
a.ReaderName,a.Sex,a.ReaderType,
a.Department,a.Class,a.Email,c.BookID,c.ReaderID
from dbo.LostInfo as c
inner join
dbo.ReaderInfo as a on (ReaderID=@ReaderID)
----a 表 c 表的 联接条件需要给出,不然就算没有语法错误,有可能结果集不正确
INNER JOIN
dbo.BookInfo AS b on (BookID=@BookID)
---- c 表 b 表的 联接条件需要给出,不然就算没有语法错误,有可能结果集不正确
不行呀!
消息 209,级别 16,状态 1,过程 SelectLostBook,第 7 行
列名 'ReaderID' 不明确。
消息 209,级别 16,状态 1,过程 SelectLostBook,第 8 行
列名 'BookID' 不明确。 给这些列明确的指出 来自于那个表。
比如 A.BookID ...
------
不行呀!
消息 209,级别 16,状态 1,过程 SelectLostBook,第 7 行
列名 'ReaderID' 不明确。
消息 209,级别 16,状态 1,过程 SelectLostBook,第 8 行
列名 'BookID' 不明确。
给这些列明确的指出 来自于那个表。
比如 A.BookID ...
@BookID CHAR(15),
@ReaderID CHAR(11)
AS
select b.ISBN,b.BookName,b.Author,b.PulishDate,b.State,b.Pulisher,b.BookTypeID,
a.ReaderName,a.Sex,a.ReaderType,a.Department,a.Class,a.Email,c.BookID,c.ReaderID from dbo.LostInfo as
c inner join dbo.ReaderInfo as a on c.ReaderID=@ReaderID INNER JOIN dbo.BookInfo AS b
on c.BookID=@BookID