Results 1 to 2 of 2
Jan 1, 2013, 08:01 #1
display data with full address, if there is any null values present?
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.
Jan 1, 2013, 10:31 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 53 Post(s)
- 2 Thread(s)
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