Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Getting started with SQL Server

delete sql with in clause

delete from t1 where (c1, c2,c3) in (select c1,c2,c3 from t2).

The above query works well in oracle... whats its equavalent in SQL Server?

Thanks

[167 byte] By [hellomahesh] at [2007-12-25]
«« INSERT, DELETE, UPDATE Staments for 2 tables
»» Dataset with two tables from different sources
# 1

That should be something like this here:

delete t1
from t1
Inner join T2
on t1.c1 = t2.c1
AND t1.c2 = t2.c2
AND t1.c3 = t2.c3

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-9-3 > top of Msdn Tech,SQL Server,Getting started with SQL Server...
# 2

Thanks Jens

hellomahesh at 2007-9-3 > top of Msdn Tech,SQL Server,Getting started with SQL Server...
SQL Server
Getting started with SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified