Queries that involve complex relationship can be handled easily using List Methods.

via Salesforce Apex : Dynamic SOQL Querying with uncertain relationship — James’ Desk