Re: real beginner PL/SQL question

In article <ron.heeb-1111961630420001_at_rheeb.csun.edu>, Ron Heeb <ron.heeb_at_csun.edu> writes
>how do i delete rows that are in one table but not in the other? i.e.
>table A has id's of 1,2,3,4,7,8 and table B has 1,2,3,4,5,6,7,8; how do i
>identify and delete 5 and 6 based on not existing in table A? thanks in
>advance, ron
>
delete from b
where b.id not in (select id from a)

-- 
Jim Smith