SOQL Join for Account & Contact Data

Question

I use a Query to get all Contacts that were changed in the last "timeframe" like this:

SELECT AccountId, Id, Email, FirstName, LastName FROM Contact WHERE LastModifiedDate >= $timeframe

I also Need the Account name but for now I only make an additional Query like this:

SELECT Name FROM Account WHERE Id = '$AccountId'

How can I combine thees two so I only need one Query and have one result set? I tried to make a Join like with normal SQL and even tried some versions I found here and on the Docs but i seem to not get it right...

Answer 1

SELECT Account.Name FROM Contact WHERE LastModifiedDate >= $timeframe

You don't need to append __r for relationships pre-defined by Salesforce.

Answer 2

This should get your result : SELECT AccountId, (select name from Account__r), Email, FirstName, LastName FROM Contact WHERE LastModifiedDate >= $timeframe