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.
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help