Fetch address from two different tables where fetch NOT NUll data from table 1 and then from B which is null in 2

Database

Fetch address from two different tables where fetch NOT NUll data from table 1 and then from B which is null in 2

Hi dnoeth,

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.

Terankit

1 REPLY

Re: Fetch address from two different tables where fetch NOT NUll data from table 1 and then from B which is null in 2

Hello,

any suggestions???A bit urgent. Thanks a lot.

Terankit