WayneBrantley wrote:

Can you please provide an example of how to do the one without the "in" clause. I cannot find any example on how to do this.

It's a field compare value predicate, where you set the ExpressionToUse property of the field you use in that predicate to the ScalarQueryExpression which performs the select.