OraFAQ Forum: SQL & PL/SQL » Outer join to more than one table

Home » SQL & PL/SQL » SQL & PL/SQL » Outer join to more than one table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Outer join to more than one table [message #35651]

Thu, 04 October 2001 04:28

Vaida
Messages: 1
Registered: October 2001

Junior Member

Is there a way of outer joining table to more than one table?

----------------------------------------------------------------------

Report message to a moderator

Re: Outer join to more than one table [message #35659 is a reply to message #35651]

Thu, 04 October 2001 06:51

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(+)

----------------------------------------------------------------------

Report message to a moderator

Re: Outer join to more than one table [message #35701 is a reply to message #35651]

Mon, 08 October 2001 01:21

senthilkumar
Messages: 9
Registered: October 2001

Junior Member

There is No way To join More Then 1 Table

----------------------------------------------------------------------

Report message to a moderator

Re: Outer join to more than one table [message #36382 is a reply to message #35701]

Fri, 23 November 2001 04:07

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

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: how to create a temp table in 7.3 ??
Next Topic:	HOW TO SET VALUE TO A VARIALBLE DECLARED IN THE PACKAGE WITH THE HELP OF ORACLE STORED PROCEDURE THA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:38:01 CST 2024