関連ワード:  left semi join sql server    left anti semi join sql server    left join vs left semi join    left semi vs inner join    left join vs semi join  
結果 : left semi join sql server