For unmatched rows returned from an outer join, the column values in the other

For unmatched rows returned from an outer join, the column
values in the other table are set to null e.g If A OUTER
JOIN B returns some unmatched rows from A, the
corresponding column values in B will be set to null. What
can be done so that a null value is not displayed for these
columns?

Question Posted / shefali799

3 Answers
6002 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / scott

Use the COALESCE function

Is This Answer Correct ?

7 Yes

0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / keshireddy

yep. With COALESCE we can

Is This Answer Correct ?

1 Yes

0 No

For unmatched rows returned from an outer join, the column values in the other table are set to nu..

Answer / sankar

You can also use VALUE

Is This Answer Correct ?

1 Yes

2 No

Post New Answer