FIX: AV Selecting View with Aggregate Subquery and Outer JoinLast reviewed: April 9, 1997Article ID: Q158269 |
6.50
The information in this article applies to:
SYMPTOMSWhen you select from a view with an aggregate subquery using an ANSI style outer join, you receive an access violation error message. For example, the following view will cause this behavior:
Create view testview as select titles.title_id, totalcount = (select count(*) from titles) from titles Left Outer Join titleauthor On titles.title_id = titleauthor.title_id WORKAROUNDReplace Left Outer Join with "*=" to avoid the access violation.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5 Service Pack 1. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
|
Additional query words:
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |