OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Joins

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

Joins [message #183807]

Mon, 24 July 2006 00:46

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

Report message to a moderator

Re: Joins [message #183809 is a reply to message #183807]

Mon, 24 July 2006 00:57

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Joins [message #184033 is a reply to message #183809]

Mon, 24 July 2006 23:29

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

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

Report message to a moderator

Re: Joins [message #184036 is a reply to message #184033]

Mon, 24 July 2006 23:43

Frank
Messages: 7901
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)

Report message to a moderator