SOQL

SOQL Joins Let's look at what we can do with this data with some familiar JOIN patterns borrowed from SQL. This time, however, we will utilize them in SOQL and also use the power of relationship traversal in path expressions that allow us to do joins implicitly. In...

Query child-to-parent relationships, which are often many-to-one. Specify these relationships directly in the SELECT, FROM, or WHERE clauses using the dot (.) operator. For example: SELECT Id, Name, Account.Name, Account.Industry FROM Contact WHERE...

which are almost always one-to-many. Specify these relationships using a subquery (enclosed in parentheses), where the initial member of the FROM clause in the subquery is related to the initial member of the outer query FROM clause. Note that for standard object...

CHAPTER 1 Introduction to SOQL and SOSL If you’ve built a custom UI for Salesforce, you can use the Salesforce Object Query Language (SOQL) and Salesforce Object Search Language (SOSL) APIs to search your organization’s Salesforce data. This guide explains when to use...

The full form of SOQL is Salesforce Object Query Language. SOQL supports some features in SQL. SOQL is similar to SQL (Structures Query Language). By using SOQL in salesforce we fetch the data in force.com. What are the SOQL features? SOQL is case insensitive. SOQL is...