Re: how to delete records in table A duplicated in table B?

From: <tigrans_at_my-deja.com>
Date: Sat, 02 Sep 2000 12:52:24 GMT
Message-ID: <8oqt64$cbp$1@nnrp1.deja.com>

delete from A where exists (select * from B where B.equalField=A.equalField)

In article <39B01682.4125FAF8_at_unisol.com>, Haral Tsitsivas <haral_at_unisol.com> wrote:
> I have two tables that contain duplicate records.
>
> How do I delete the records in table A that are duplicated in table B?
> The tables are identical but must contain different data...
>
> Two of the table columns could be used to guarantee uniqueness when
> performing the select. Should an index be created to speed up the
> selection or would that slow things down more?
>
> Thanks
>
> --Haral
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 02 2000 - 07:52:24 CDT