Outer join column may not be used with an IN predicate or subquery.

There is an error in the syntax of your query. The Query Designer has attempted to locate the source of the error. Review your query syntax and correct the error before running your query.

For more information, see How to: Create Outer Joins (Visual Database Tools).

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance