SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

joining 3 tables with null values

335578Dec 12 2002

Hi,

I have three tables that have varying data in. I want to write a query which will list all three in the result set, but when one of the tables doesn't have a row, write in No Value.
I will be intending on joining the tables with account numbers. What will be the syntax of a join with three tables where I am not sure which table will have null values?

Thanks...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2003

Added on Dec 12 2002

1 comment

356 views