Networks·41,454 discussions

SQL 6.5 multiple Outer Join problem

Locked

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.

Topic

SQL 6.5 multiple Outer Join problem

In reply to SQL 6.5 multiple Outer Join problem

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.

SQL 6.5 multiple Outer Join problem

In reply to SQL 6.5 multiple Outer Join problem

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

[Author]

Replies