関連ワード:  case statement in sql left join    left outer join with case statement in sql server  
結果 : case statement in sql left join