The Query Designer requires that you follow specific rules when designing queries. This error may appear if you have used the Diagram pane 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 About Creating Queries.