Hi All,

Thanks to your inputs, I was able to do what I want.

DELETE TABLE

FROM TABLE

JOIN (SUBQUERY)

I think this was how I first perceived the SQL statements but I was surprised that there was a RowID field in MSSQL 2k5.

I googled for it and tried it also, its fast and concise. Thanks for your help again . I might post other questions though later (because of all of you being friendly) 😀