![]() ![]() ![]() This way you are recreating the original attempt of joining an inner query to an outer query. A simple solution is to create another table instance as part of the inner query – and correlate it with the outer table by ensuring the JOIN is based on the outer table key. ![]() The first query tries to create a SUM with a reference from the inner query to the outer query. SQL Server has to solve the problem of which query it will use for aggregate computation If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression.Īnswer: In summary, SQL Server experiences problems when mixing outer and inner references for aggregate expressions. Multiple columns are specified in an aggregated expression containing an outer reference. Question: How do I fix a query with an aggregate expression containing an outer reference returning this error message:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |