Home » SQL & PL/SQL » SQL & PL/SQL » OUT JOIN
OUT JOIN [message #190743] Fri, 01 September 2006 01:53 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

Is outer join in a correlated subquery works?
That means outer join can use in coorelatd subquery?

regards,


Re: OUT JOIN [message #190744 is a reply to message #190743] Fri, 01 September 2006 01:55 Go to previous messageGo to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi

I think it's not work


regards,

SamC
Re: OUT JOIN [message #190774 is a reply to message #190744] Fri, 01 September 2006 03:19 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Please give us a SMALL example of what You cannot make work.

Br
Kim
Re: OUT JOIN [message #191190 is a reply to message #190774] Tue, 05 September 2006 02:33 Go to previous messageGo to next message
senthilk44
Messages: 5
Registered: September 2006
Junior Member
y we are using left outer join & right outer join,

instead of using right outer join,can i interchange the table names in the left outer join?
Re: OUT JOIN [message #191192 is a reply to message #191190] Tue, 05 September 2006 02:35 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Have You tried it?
What happens when You try it?

Br
Kim
Re: OUT JOIN [message #191193 is a reply to message #191192] Tue, 05 September 2006 02:39 Go to previous message
senthilk44
Messages: 5
Registered: September 2006
Junior Member
join between 2 table i tried,it's same

but i didnt tried for join between more than 2 tables
Previous Topic: changing schema using PLSQL
Next Topic: Load Log file into Oracle
Goto Forum:
  


Current Time: Sat Dec 10 06:54:18 CST 2016

Total time taken to generate the page: 0.08051 seconds