I'm having trouble trying to figure out what's wrong with this SOQL sentence:
SELECT Id, FormulaField__c, CurrencyField__c FROM MyTable WHERE FormulaField__c != CurrencyField__c AND FieldA__c = 1
This is the context:
FormulaField__c: is a formula field returning a currency value CurrencyField__c: currency field edited manually in the point & click view. FieldA__c: just another field
Developer console, introverted as usual, only says: "Unknown error parsing query". I know the conflicted part of the query is the following comparison:
FormulaField__c != CurrencyField__c
because when I remove it, query executes just fine.
Can any one give me a hint of what's going on here and how can I solved it?
Thanks in advance