Re: Deleting records where they are in another table

Anurag Varma wrote:
> ORA92> delete (select a.* from testA a, testB b where a.id = b.id and
> a.d1 = b.d1);
>
> 26 rows deleted.
>
> ... should work provided the tables have a PK on the id and date
> columns....
>
> Anurag

I forgot about update views which is what Anurag example is called.

• Mark D Powell --