Ignoring illegal use of ALL
There is an error in the syntax of your query. SQL Server Enterprise Manager has attempted to locate the source of the error.
Although the query will run, you should review your query syntax and correct the error.
| Expressions | GROUP BY and ALL |
| Filtering Rows with WHERE and HAVING | Query Fundamentals |