Ignoring illegal use of ALL.
There is an error in the syntax of your query. The Query Designer has attempted to locate the source of the error. Although the query will run, you should review your query syntax and correct the error.
For more information, see About Creating Queries.