Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL delete using multiple "where" columns
Thanks for your help there. I found another solution to the problem (at 2am !!) delete from t1 from t1 A, t2 B where A.f1=B.f1 and A.f2=B.f2 This "first from clause", "second from clause" was new to me but it seems work. The "second from" allows the...- ralc
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
SQL delete using multiple "where" columns
Hi I have 2 tables : t1 is the main data table with 3 fields t2 is a driver table which will drive the delete t1 t2 ========== ====== f1 f2 f3 f1 f2 a 1 do a 1 a 2 re b 2 b 2 mi c 5 c 2 fa c 3 so I want to delete all...- ralc
- Thread
- Replies: 5
- Forum: Sybase: Adaptive (SQL) Server
