Re: real beginner PL/SQL question
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1996/11/12
Message-ID: <56aidl$kq4_at_shadow.CSUFresno.EDU>#1/1
Date: 1996/11/12
Message-ID: <56aidl$kq4_at_shadow.CSUFresno.EDU>#1/1
This works:
DELETE FROM A WHERE ID IN (SELECT ID FROM A MINUS SELECT ID FROM B);
Steve Cosner
In article <ron.heeb-1111961630420001_at_rheeb.csun.edu>,
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?
Received on Tue Nov 12 1996 - 00:00:00 CET