在項目中出現的left join 查詢在on後面用case的語法,弄了好久,終於搞定了,以作備忘.
示列:
select * from AIRPORTORDER as A
inner join RANGECODE as B
on
case when A.AIRPORDER_GOORBACK='2' then A.AIRPORDER_ENDCODE
when A.AIRPORDER_GOORBACK='1' then A.AIRPORDER_STARTCODE
end =B.RANGECODE_NO
GO