you can use sub-select in delete clause provided the sub-select returns only one value:
delete from b
where account_num = (select a.account_num from a,b
where a.account_num = b.account_num);
|
Results 1 to 2 of 2
Thread: Delete StatementThreaded View
|
Click Here to Expand Forum to Full Width |