need a help from you. We are inserting rows(address details) in table A by Inner joining this table with B, C and D. D is having address and we are taking address which is NOT NULL.
Then in next step we are once again inserting the Address Details in A by Inner joining this with B,C and E. This time we are trying to fetch the address from E which we did not get from D(i.e. which was NULL in D).
Is there any efficient way to day this(in single step or any other efficient way) or we are doing it in right way?
Thanks for your help in advance.
any suggestions???A bit urgent. Thanks a lot.