MSSQL JOIN查询 - '值'附近的语法不正确(MSSQL JOIN Query - Incorrect Syntax Near 'Value')

 我有一个查询，我没有在视觉上看到语法或格式错误。 
 
 但是，在执行时，SSMS报告“值”附近存在语法错误。 
 
select * from sw.Users u 
join sw.Locations l 
join sw.Organizations o 
on u.LocationID = l.LocationID 
and l.OrganizationID = o.OrganizationID 
and o.OrganizationName = 'Value'
 
 错误 
 
 
 
 消息102，级别15，状态1，行38'值'附近的语法不正确。 
 
 
 尝试以下结果： 
 
select * from sw.Users u 
join sw.Locations l 
on u.LocationID = l.LocationID
 
 为什么第一个连接查询报告错误？ 

I have a query for which I have not visually seen syntax or formatting errors.
 
However upon execution, SSMS reports that there is a syntax error near 'Value'.
 
select * from sw.Users u 
join sw.Locations l 
join sw.Organizations o 
on u.LocationID = l.LocationID 
and l.OrganizationID = o.OrganizationID 
and o.OrganizationName = 'Value'
 
Error
 
 
 
Msg 102, Level 15, State 1, Line 38 Incorrect syntax near 'Value'.
 
 
Trying the following works with results:
 
select * from sw.Users u 
join sw.Locations l 
on u.LocationID = l.LocationID
 
Why is the first join query reporting the error?

原文：https://stackoverflow.com/questions/41815772