Home » RDBMS Server » Server Administration » Joining multiple tables again!
Joining multiple tables again! [message #374705] Mon, 25 June 2001 15:47 Go to next message
rgallazzi
Messages: 6
Registered: June 2001
Junior Member
Hi again... the last question i've asked wasn't so clear.
I have do retrieve the null records in more than 7 different tables, so i have to use the outer join (+), but i can't do this in more than 2 tables. How can i do??
thanks

Report message to a moderator

Re: Joining multiple tables again! [message #374709 is a reply to message #374705] Mon, 25 June 2001 19:37 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
You need to break the outer joins into separate queries:

select t1.x, v.y, v.z from t1, (select t2.y, t3.z from
t2, t3 where t2.joincol=t3.joincol (+)) v and t1.joicol=v.joincol (+);

Report message to a moderator

Previous Topic: Limit records returned by a select
Next Topic: urgent query not yet solved!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 19:03:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.