无法绑定由多部分组成的标识符"Reservation.ReservationID“

Question

我正在尝试这样的内部连接。

select R.ReservationID, R.BookingNumber,P.FirstName, P.LastName  
from Reservation R inner join PersonName P 
on Reservation.ReservationID = PersonName.ResrvationID 

我得到的错误如下：

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "Reservation.ReservationID" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "PersonName.ResrvationID" could not be bound.

Answer 1

别名"R“和"P”掩蔽了实际的表名。

虽然它不适用于这里，但它通常是有意义的。例如，当您有一个自连接时

select R.ReservationID, R.BookingNumber,P.FirstName, P.LastName  
from Reservation R inner join PersonName P 
on R.ReservationID = P.ReservationID --use aliasas

Answer 2

试一试

select 
  R.ReservationID
, R.BookingNumber
, P.FirstName
, P.LastName   

from Reservation R 
inner join PersonName P  
on R.ReservationID = P.ResrvationID