Apex Code Development You need to sign in to do that
Don't have an account?
Complex SQL scripts
Dear all,
I was looking into the community some solutions about how to create complex SQL Scripts.
Last week, I started in a company that they use SalesForce. So I have been learning about it.
I would like to receive some advices about create complex tables join (Inner Join, Left join, etc). Salesforce doesn't offer this funcionalities as SQL Server.
Thanks in advance for your support. I hope to become an expert soon and help other people.
I was looking into the community some solutions about how to create complex SQL Scripts.
Last week, I started in a company that they use SalesForce. So I have been learning about it.
I would like to receive some advices about create complex tables join (Inner Join, Left join, etc). Salesforce doesn't offer this funcionalities as SQL Server.
Thanks in advance for your support. I hope to become an expert soon and help other people.
Yes, SOQL is not as comprehensive as SQL, but Salesforce does provide ways to do Inner join etc. Here is an article that might help:
https://developer.salesforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com