I am new to using the perdicate expressions, can someone help me to write this?

Can this even be done with LLBL?

SELECT * FROM ProductDiscount WHERE 
Product_ID IN (
SELECT Product_ID
FROM ProductDiscount
GROUP BY Product_ID
HAVING SUM(IsPercentage) = 0 AND SUM(PerItem) = COUNT(*)
)

Thanks in advance JS

It's possible. Please read the FieldCompareSetPredicate and let us know if you need further help.