raghuveer126 (10/18/2012)
i have datawarehouse database where there is only primary key and no foreign keys.I have a condition from one table and based on that condition i have to delete the records from other tables.
I am trying to use joins and delete the records based on that condition. Is this right way or else anyother way to delete.
1. It might be the right way.
2. There is a possibility that there are other ways exist which you can use to delete.
That about the best answer I can think of, based on details you have provided.