试试这个

select tblPersonalInfo.companyname, tblJobBudget.title,tblJobBudget.lastmodifiedby,
tblJobAdv.advtitle, tblJobAdv.userId,
tblApplication.advid, tblApplication.position
from tblJobAdv
inner join tblApplication
ON tblJobAdv.advid = tblApplication.advid
inner join tblPersonalInfo
On tblJobBudget.lastmodifiedby = tblPersonalInfo.userid

给出错误
Msg 4104, Level 16, State 1, Line 8
The multi-part identifier "tblJobBudget.lastmodifiedby" could not be bound.
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "tblJobBudget.title" could not be bound.
Msg 4104, Level 16, State 1, Line 2

不能绑定(bind)多部分标识符“tblJobBudget.lastmodifiedby”。

最佳答案

这是因为没有任何带有tblJobBudget标识符的表或表别名。

您的表是:

  • tblJobAdv
  • tblApplication
  • tblPersonalInfo

  • 但不是:
  • tblJobBudget

  • 如果您需要表tblJobBudget中的列,则应在带有tblJobBudget子句的表中包括join:
    from       tblJobAdv
    inner join tblApplication
       ON tblJobAdv.advid = tblApplication.advid
    inner join tblJobBudget                              <--here
       ON ...
    inner join tblPersonalInfo
       ON ...
    

    10-05 19:45