두개의 테이블 조인하여 DELETE, UPDATE 문 사용하기

1. DELETE

delete from table_a awhere column_A in (select column_B from table_b b where a.column_A = b.column_B);
혹은
delete from table_a awhere exists (select ‘x’ from table_b b where a.column_A = b.column_B);

2. UPDATE

update table_a a
set (cust_name, cust_num)  = (select b.고객이름, b.고객번호  from table_b b where a.column_A = b.column_B );