Listing 5-29 SOQL with Child-to-Parent Relationship

SELECT Name, Contact__r.MailingCity, Contact__r.CreatedBy.Name
FROM Resource__c WHERE Contact__r.MailingState = 'IL'