I have what should be a very simple SOQL query that I get an error thrown on. The two fields in the WHERE clause are both Decimal types.
SELECT Id, Parent_Object__r.Amount__c, Amount__c FROM Child WHERE Parent_Object__r.Amount__c = Amount__c
I am getting a MALFORMED QUERY exception thrown for some reason. Does anyone know why this might be?