関連ワード:  sql left join with nested select    sql left join nested query    difference between join and left join  
結果 : sql left join with nested select