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