Link to home
Start Free TrialLog in
Avatar of felkamau
felkamau

asked on

Maximum number of joins allowed in single SQL statement

I have a gigantic SQL statement that has 10 left outer joins and 2 inner joins. what is the maximum number of joins SQL will allow...i tried adding another left join but got this error message:
The correlation name 'Foreign Key' is specified multiple times in a FROM clause.
Avatar of trainsdse
trainsdse

Maybe just paste in the from clause so we can see.
ASKER CERTIFIED SOLUTION
Avatar of Brendt Hess
Brendt Hess
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I agree with bhess1, sure would help if we had the from clause :)