Re: Newbie: delete from multiple tables?

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Fri, 18 Jul 2003 21:41:04 +0200
Message-ID: <bf9igg$amc$1@svr8.m-online.net>

I just tried it with Oracle 8.1.7 and PostgreSQL 7.2.1 It works with both...

Cheers
Thomas

JJ Reynolds schrieb:

> It's recent.. I know it works in 9i, but not sure about 8i (don't have an 8i
> instance to try it on).  It absolutely did not work in 7.x.
> 

> 
> "Thomas Kellerer" <spam_eater_at_gmx.net> wrote in message
> news:bf9cia$8rs$1_at_svr8.m-online.net...
> 

>>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 - 14:41:04 CDT