関連ワード:  left join with select subquery sql server    difference between subquery and join    join vs subquery which is better    when to use subquery and when to use joins  
結果 : left join with select subquery sql server