delete with IN clause

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

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

Thanks

Double: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=802302&SiteID=1

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

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

|||

Thanks Jens