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 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.
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
This topic is now closed. New replies are no longer allowed.