Salesforce Object Query Language (SOQL)

Use the Salesforce Object Query Language (SOQL) to construct simple but powerful query strings for the queryString parameter in the query() call. Similar to the SELECT command in Structured Query Language (SQL), SOQL allows you to specify the source object (such as Account), a list of fields to retrieve, and conditions for selecting rows in the source object.

Note
SOQL does not support all advanced features of the SQL SELECT command. For example, you cannot use SOQL to perform arbitrary join operations, use wildcards in field lists, or use calculation expressions.

Use the following topics to understand the components of a SOQL SELECT, their syntax and usage:

© Copyright 2000-2008 salesforce.com, inc. All rights reserved.
Various trademarks held by their respective owners.