table1 having nulls then fetch from table2 ?
I have two tables with columns as;
Now i want to write a query as,
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.