Discussion Locked

SQL 6.5 multiple Outer Join problem

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Receiving Msg 301, Level 16, State 1
Query contains an illegal outer-join request.

Scenario: Table A left join to B, then I need B to left join to C. Also, Table A left join to D, then left join D to E,F,and G.

2 replies

by pvp

See Q151513 in the KB.

This is bug #15265. Among the listed causes, you seem to hit "more than 5 tables involved in the join".

The published workaround is to use Trace Flag 320 to disable the "outer join heuristic".

Supposedly, this has been fixed with SP1.

by kbecknell

I found that on Microsoft's web site and tried it, but it didn't work. I have SP 5A.
Thanks anyway.

This discussion is closed to new replies.