Outer join to more than one table [message #35651] |
Thu, 04 October 2001 04:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Vaida
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
Is there a way of outer joining table to more than one table?
----------------------------------------------------------------------
|
|
|
Re: Outer join to more than one table [message #35659 is a reply to message #35651] |
Thu, 04 October 2001 06:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
m
Messages: 15 Registered: April 2001
|
Junior Member |
|
|
SELECT *
FROM (select *
from t1, t2
where t1.t1c1 = t2.t2c1(+)) t_v,
t3
WHERE t_v.t1c1 = t3.t3c1(+)
----------------------------------------------------------------------
|
|
|
|
Re: Outer join to more than one table [message #36382 is a reply to message #35701] |
Fri, 23 November 2001 04:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Danny
Messages: 11 Registered: June 2001
|
Junior Member |
|
|
hi
I got the problems...??
How
to show all the retraive marching data and also not marching data in outer join
what the differents Right outer joint and left Outer joint
could You plz give me examples all of them
thankz before
danny
----------------------------------------------------------------------
|
|
|