Posted by Erland Sommarskog on 10/01/39 11:22

David Portas (REMOVE_BEFORE_REPLYING_dportas@acm.org) writes:
> DELETE FROM T1
> WHERE EXISTS
> (SELECT *
> FROM T2
> WHERE T1.a = T2.c
> AND T1.b = T2.d) ;

Which should be added, is a syntax that also works in Oracle.

Then again the syntax with IN that Oracle has is, as far as I know,
ANSI-compliant, so SQL Server is at fault here.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Yukon XQuery question
• Prev in forum: Re: Need help with SQL query. Keyword matching.
• Thread view: Re: Aggregate column comparison in sql server sql ?

[Reply to this message]