Query child-to-parent relationships

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 Account.Industry = 'Energy'

This query returns the ID and name for only the contacts whose related account industry is Energy, and for each contact returned, the account name.