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 Specifying Search Criteria (Visual Database Tools) and How to: Specify Search Conditions (Visual Database Tools).