Re: I Need Help On A Delete Statement

From: <oratune_at_aol.com>
Date: Fri, 27 Oct 2000 02:33:19 GMT
Message-ID: <8taphf$kls$1@nnrp1.deja.com>

 delete from address_1 a
 where a.field_1 = (select b.field_1 from address_2 b

                              WHERE substr(a.field_2,1,10) =

 substr(b.field_2,1,10));

I believe this should work.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Thu Oct 26 2000 - 21:33:19 CDT