Appropriate SQL cannot be generated.
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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).

© 2016 Microsoft