How do I write the below SQL Query using Adaptor scenario (LLBL 2.0)

SELECT PLIContainerID, CountryID FROM StudyCountry WHERE (PLIContainerID IN (SELECT PLIContainerID FROM PLIContainer WHERE (PLIParentContainerID = @pliContainerID)))

Many Thanx

Check out FieldCompareSetPredicate class.

mihies wrote:

Check out FieldCompareSetPredicate class.

Fine.

I just want some brief info on how I can use IN in my conditions

Please check the predicate documentation in the manual under filtering and sorting. You'll find examples etc. there.