无法绑定由多个部分组成的标识符 "t_R_Websource_Sresult.author"。

[Srawo]

select dbo.t_searchresult.* ,dbo.t_category.category ,dbo.t_searchEng.name,1 as stype,t_R_Seng_Sresult.t_R_kseng_Sresultid as pkid ,t_R_Seng_Sresult.getdate ,t_R_Seng_Sresult.changedate
from t_searchresult
left join
t_R_Seng_Sresult on t_R_Seng_Sresult.Sresultid=t_searchresult.sid
left join
t_category on t_category.categoryid=t_R_Seng_Sresult.categoryid
left join
t_searchEng on t_searchEng.SEngid=t_R_Seng_Sresult.sengid


where t_searchResult.title='青岛法院网' or t_R_Websource_Sresult.author='青岛法院网'

大师们,这个错是怎么回事呀= =

消息 4104，级别 16，状态 1，第 1 行

[htl258_Tony]

t_R_Websource_Sresult--没看到有连接到这个表啊

[htl258_Tony]

太花了,帮你整下:

select a.* ,c.category ,d.name,1 as stype,b.t_R_kseng_Sresultid as pkid ,b.[getdate] ,b.changedate 
from t_searchresult a
  left join t_R_Seng_Sresult b
    on a.Sresultid=b.sid 
  left join t_category c 
    on c.categoryid=a.categoryid 
  left join t_searchEng d
    on d.SEngid=b.sengid 
where a.title='青岛法院网' 
  --or t_R_Websource_Sresult.author='青岛法院网'