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.
The correlation name 'Foreign Key' is specified multiple times in a FROM clause.
Maybe just paste in the from clause so we can see.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with bhess1, sure would help if we had the from clause :)