#1 Select Queries in where statements

[Luke Foust]

Currently, the library does not support the following
scenario:

update myfield set myVal = 2 where myField2 in (
select myField from myTable
)

This could be accomplished by adding an overload to the
WhereTerm.CreateIn method which takes a SelectQuery.
You could even throw an exception if there is more than
one select item in the SelectQuery.

So far I am very impressed with your library and its
slick design.

Thank You.

[Alon Catz]

Logged In: YES
user_id=701386

The last versions support Sub Queries in WHERE statement
in general and in the IN clause specifically.