関連ワード:  t sql update with select subquery    t sql insert with select subquery    t sql select subquery    when to use subquery and when to use joins  
結果 : t sql update with select subquery