SQL 6.5 multiple Outer Join problem
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.
Networks
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.
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.
Sort by Trending