Need Help With Delete Syntax

From: Socalman <socalman_at_linkline.com>
Date: Thu, 26 Oct 2000 18:22:03 -0700
Message-ID: <39F8D8BB.D7D15A16@linkline.com>

I must be brain dead because I have done this in the past. I have two tables in Oracle that are identical, tables "address_1" & "address_2". I want to delete any duplicate addresses that may be on address_1 and address_2. So, I thought the syntax would be something like this:

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

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

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

Please help if you can. I know it's a simple problem, but I'm running on empty!

Thanks, email: socalman_at_linkline.com Received on Thu Oct 26 2000 - 20:22:03 CDT