Salesforce Platform Developer I Certification Guide

SELECT fieldList [subquery] [...]

This query specifies a list of one or more fields, separated by commas, that you want to retrieve from the specified object. The bold elements in the following examples are lists of fields:

SELECT Id, Name, Genre__c FROM Movie__cSELECT COUNT() FROM Cast__cSELECT Movie__r.Name, Name FROM Cast__c

You need to specify at least one valid field name, and you must have read-level permissions for each field specified in the query. The list can include a subquery if you want to select child records that are related to a parent record. You can only select one level deep for related records. The following is an example:

SELECT Name, (SELECT Name FROM Cast__r) FROM Movie__c

In the previous query, we actually say this: ...