What steps will reproduce the problem? 1. Create a query that contains an IN/NOT IN subquery, where the subquery's select statement is an aggregate, instead of a normal Select column.

What is the expected output? Expect the outer query to run successfully.

What do you see instead? An error message like 'You must specify a column to return for the IN to be valid. Use Select("column") to do this'

What version of the product are you using? Rev 479.

On what operating system? XP

Please provide any additional information below. The attached patch resolves this issue in SqlQuery\Contstraint.cs.

Fixed with revision 500