Home » SQL & PL/SQL » SQL & PL/SQL » Outer join to more than one table
Outer join to more than one table [message #35651] Thu, 04 October 2001 04:28 Go to next message
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 messageGo to next message
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 #35701 is a reply to message #35651] Mon, 08 October 2001 01:21 Go to previous messageGo to next message
senthilkumar
Messages: 9
Registered: October 2001
Junior Member
There is No way To join More Then 1 Table

----------------------------------------------------------------------
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
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

----------------------------------------------------------------------
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:
  


Current Time: Fri Mar 29 00:53:11 CDT 2024