Hello,

Does anyone know how I could get LLBLGen to construct a query similar to:

SELECT * FROM Registration

WHERE

RegistrationID IN ( SELECT RegistrationID FROM Registration_Capability RC WHERE CapabilityID IN (237) )

AND

RegistrationID IN ( SELECT RegistrationID FROM Registration_Capability RC WHERE CapabilityID IN (253) )

Thanks!

Hi roastmb,

You should use FieldCompareSetPredicate. Please review the LLBLGenPro Help - Using Generated Code - Adapter (of SelfServicing) - Filtering and Sorting - The predicate system - FieldCompareSetPredicate for the IN Clause subquery. These threads may give you some lights too: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8676 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9290

CapabilityID IN (237)

Is there a specific reason for you used IN instead of Equal (=)?

Regards