raghuveer126 (10/22/2012)
I did inner join put a where clause and deleted one table there were x rows affected but when i try to put one more table from the inner joins i used in the delete statement it is not deleting the related records in that table, it says 0 rows affected.If it has no foreign keys than how do i know which table to delete first...
first you should verify the data by select it before deleting it. another thing one query will delete the data from one table at a time (i havent seen anything link Delete table1, table2 from .............) then another query for second deletion
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)