May 25th, 2005, 01:46 AM
|
|
Contributing User
|
|
Join Date: Mar 2003
Location: Hong Kong
Posts: 41
Time spent in forums: 1 h 24 m 4 sec
Reputation Power: 6
|
|
|
Three Table in full outer join
What the SQL should be for Three table in full outer join?
I want the output of join field in either one of table should show if either one of them has values.
Is it correct?
select nvl(A.field1, nvl(B.field1, C.field1))
from table A (full outer join Table B on
A.field1=B.field1) full outer join Table C
on A.field1=C.field1
??
__________________
Real, Nice and Beautiful are my hungry for knowledges.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
