sql server 中join 查詢中on後面 加case的用法.

 

在項目中出現的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