Home » SQL & PL/SQL » SQL & PL/SQL » Joins
Joins [message #183807] Mon, 24 July 2006 00:46 Go to next message
pamrajrajeev
Messages: 9
Registered: July 2006
Junior Member
Hai,

When we are working with joins, How many joins(join conditions on tables) can be applied. Do we have any limitation.




Regards
Rajeev
Re: Joins [message #183809 is a reply to message #183807] Mon, 24 July 2006 00:57 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, there's no such a limitation; unless you want to include more than 255 subqueries into the WHERE clause, or more than 1000 elements into the IN clause.
Re: Joins [message #184033 is a reply to message #183809] Mon, 24 July 2006 23:29 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
for doing n joins you need to specify n-1 conditions
basic dear watson
Re: Joins [message #184036 is a reply to message #184033] Mon, 24 July 2006 23:43 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
amul wrote on Tue, 25 July 2006 06:29

for doing n joins you need to specify n-1 conditions
basic dear watson

ever heard of compound or composite foreign keys? That would increase your number of conditions.
Also basic.

(apart from the fact that it was not what the OP asked)
Re: Joins [message #184107 is a reply to message #184036] Tue, 25 July 2006 07:08 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
well i understand now..sorry bout being sarcastic,and thnx for makin me learn it.
Re: Joins [message #184209 is a reply to message #184107] Tue, 25 July 2006 14:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
no problem Wink
Been corrected myself way too many times. Especially when being sarcastic.
Re: Joins [message #184235 is a reply to message #184209] Tue, 25 July 2006 17:39 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Oh have you really.

(And it's 'Elementary'.)
Previous Topic: Decode, NVL or which do I use?
Next Topic: not exists
Goto Forum:
  


Current Time: Sun Dec 11 06:20:20 CST 2016

Total time taken to generate the page: 0.19609 seconds