The information in this article applies to:
SYMPTOMS
A complex SELECT query that contains multiple LEFT OUTER JOIN tables in the
FROM clause may cause a handled access violation (AV). For example, if the
tables used in the query are very wide, the following ANSI-style left outer
join query may cause handled AV when executed:
WORKAROUNDYou may be able to work around this problem by using the non-ANSI-style outer joins. For example, instead of using LEFT OUTER JOIN in the FROM clause, you can use the left outer join operator, that is, "*=", in the WHERE clause, and list all the tables involved in the FROM clause. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words: ANSI AV
Keywords : kbbug6.50 |
Last Reviewed: March 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |