+ Start a Discussion

Apex Data Loader SQL command

Select Id, Billing_City__c, Billing_Country__c FROM Contact WHERE Billing_City__c = Billing_Country_c
From the above SOQL i will get a error message saying that "Billing_Country_c" must be a string that have ' '.
But the purpose of my SOQL is to find out whether Billing_City_c got any duplicates in Billing_Country_c
Can any1 help me?
are you trying to retieve all records which has Billing_City_c = Billing_Country_c ??
try this

Select C1.Id, C1.Billing_City_c, C1.Billing_Country_c FROM Contact C1, Contact C2 WHERE C1.Billing_City_c = C2.Billing_City_c AND C1.Billing_City_c = C2.Billing_Country_c
Dear Jerry,
The code u provided doesnt seems to work.
I don't believe it is possible, but I'd love to hear about a way to do it!

The SOQL documentation states that the Value after the Comparison Operator is not another field:
A value used to compare with the value in fieldName. You must supply a value whose data type matches the field type of the specified field. You must supply a native value—other field names or calculations are not permitted. For date values, use the formatting listed in Date Formats and Date Literals. If quotes are required (for example, they are not for dates and numbers), use single quotes. Double quotes result in an error.