join update/delete

대략 아래와 같이

 

update table1
 set table1.data = 'a'
from table2
where table1.id = table2.id
 and table2.seq = '100';

 

 

delete table1
from table2
where table1.id = table2.id
 and table1.seq = '100';