Re: real beginner PL/SQL question

delete from B
 where ID in (select ID from B

              minus
              select ID from A
             )

Ron Heeb (ron.heeb_at_csun.edu) wrote:
: 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
 

: --
: Ron Heeb, Webmaster
: Mgr., Applications Development, ITR
: California State University, Northridge
: email: ron.heeb_at_csun.edu, webmaster_at_csun.edu

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.