Display data with full address, if there is any null values present?

Databases
1

Hi all,

I have two tables with columns as;

in table1;

empno,ename,address1,address2,address3,city,state

in table2;

empno,ename,address11,address22,address33,city,state

Now i want to write a query as,

to display the table1 data with full address, if there is any null values present in table1 in address (address1,address2,address3) columns, i want to fetch that row address (address11,address22,address33) columns from table2 for that corresponding row based on the empno and display at a time.

Please give me an idea to resolve this problem soon.

Thanking you.

2

for “corresponding row” you will need to do a JOIN

if table2 row always exists for corresponding table1 row, use an INNER JOIN

then use COALESCE function so that, for example, if address1 is null, it returns address11