Re: Newbie: delete from multiple tables?

JJ Reynolds schrieb:
> or.. an even cuter syntax!
>
> delete from t1 where (col1, col2) in (select col1, col2 from t2);
>
>

This is cool :)

I didn't know that this is possible.
After so many years of SQL experience one can still learn new things..

Cheers
Thomas Received on Fri Jul 18 2003 - 12:59:38 CDT