Hello

I have two tables Group and GroupItem, where a Group contains GroupItems. I want to select all group names which contain items, ie not show any groups where their id does not exist in the group item table.

I know this sounds really simple, but for some reason I am really struggling.

Can you help?

Thanks

Bex

You could use the FieldCompareSetPredicate, should look like:

RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.AddWithAnd(new FieldCompareSetPredicate(GroupFields.GroupId,
                    GroupItemFields.GroupId, SetOperator.In, (GroupFields.GroupId == GroupItemFields.GroupId), false));

Find at the Docs or Forums for FieldCompareSetPredicate for more info