The Microsoft Visual Database Tools Query Designer requires that you follow specific rules when designing queries. This error may appear if you have used the Diagram or Grid pane to create a query that cannot be expressed in an SQL statement. Verify the query options you have selected.
For more information, see Creating Queries and Specifying Search Criteria.