Re: Newbie: delete from multiple tables?

Niall Litchfield wrote:
>
> SQL> delete t1
> 2 where exists (
> 3 select null from t2
> 4 where t1.id=t2.id
> 5 and t1.col2=t2.col2);
>

I was just about to post an answer with that version of the delete statement as well :-)

I would think that this is more efficient then having two subselects.

Thomas Received on Thu Jul 17 2003 - 10:23:42 CDT