hello,

i'm wondering if it is possible to filter by comparing a field in the parent and a field in child.  Example, I have a parent object Merchandise that has field Price and it has a child object Line Items with Unit Price.  I was thinking...

SELECT Unit_Price__c, Merchandise.Price__c FROM Line_Item__c 

          WHERE Merchandise.Price__c < Unit_Price__c

However, it doesn't seem to allow that.  Is that a limitation or I just got the wrong query?

Thanks!