Appropriate SQL cannot be generated.

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

Community Additions