所以我试图将一些东西从MySql转换为MSSQL 2012问题是我不知道Sql那么好,知道这个语句有什么问题。当这与MSSQL数据库具有相同的信息时,我得到一个响应。
我得到错误:
关键字'where'附近语法错误。Msg: 156, Level: 15, State: 1, Procedure:, Line: 11
select distinct
coalesce(s.state_prov, ls.state_prov, 'State Unknown') as state_prov
from
circuit_id_locations cid
join
location_states ls
left join
location_states s
on
cid.state_prov = s.abreviation
where
ls.idx = '99'
or
cid.id = '99'
你有更多的JOIN
s比你做ON
条款,把你的正常连接到CROSS JOIN
,使其工作。
select distinct
coalesce(s.state_prov, ls.state_prov, 'State Unknown') as state_prov
from
circuit_id_locations cid
CROSS join
location_states ls
left join
location_states s
on
cid.state_prov = s.abreviation
where
ls.idx = '99'
or
cid.id = '99'
你有一个没有'on '语句的join语句
>>>MISSING JOIN TYPE (inner/left/right/cross)<<< join
location_states ls
>>>MISSING ON<<<
加入Location_states