Hi!
I would like to do an import of a Salesforce report with 13000 lines.
To do so I need to use the custom query import mode.
The problem I have is that i need to use some fieds located in Opportunity table and other in Lead table.
I wrote :
Select Field A, Field B
From Lead , Opportunity
but it is not working.
Can you help me ?
Thanks
Best answer by Julien
Hi
You probably need to add a WHERE clause to specify how the data should be referenced between the 2 tables.
Check the Relationship Queries from SFDC’s documentation for some examples on how you can format your query: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm
Maybe something like this would work?
SELECT Lead.FieldA, Opportunity.FieldB
FROM Lead, Opportunity
WHERE Lead.ConvertedAccountId = Opportunity.AccountId
+8Hi
You probably need to add a WHERE clause to specify how the data should be referenced between the 2 tables.
Check the Relationship Queries from SFDC’s documentation for some examples on how you can format your query: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm
Maybe something like this would work?
SELECT Lead.FieldA, Opportunity.FieldB
FROM Lead, Opportunity
WHERE Lead.ConvertedAccountId = Opportunity.AccountId
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.