--------------------------------------------------
◆INSERT
--------------------------------------------------
■select結果を既存テーブルにinsert
insert into [INSERT先テーブル名] select * from [元テーブル名] where ~
■select結果を、まだ存在しないテーブルにinsert
SELECT * INTO [作成&insert先テーブル名] FROM table1 as a
--------------------------------------------------
◆UPDATE
--------------------------------------------------
■別テーブルをJOINして UPDATE
UPDATE a SET a.a1 = b.a2
FROM TableA AS a
INNER JOIN TableB AS b ON a.ID1 = b.ID1
--------------------------------------------------
◆DELETE
--------------------------------------------------
■別テーブルとjoinした行を削除
delete t1
from table1 as t1
inner join table2 as t2
on t1.key = t2.key
where t2.col1 = 'xxx'