to display the table1 data with full address,
if there is null values present in table1 in address columns (i.e all there address1,address2,address3 columns are null) , i want to fetch that row address (from address11,address22,address33 columns) from table2 for that row based on the empno and display at a time.
Please give me an idea to resolve this problem soon.
But that COALESCE function is checking one by one column.
i want to check if all the 3 columns are null (but not any one or two), then only i want to go for second-table address columns?