You need to sign in to do that
Don't have an account?
Kun
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?
Thanks
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
The SOQL documentation states that the Value after the Comparison Operator is not another field: