Querying child object fields from Parent
101732
how to Query parent to child
133610
How to access fields from the inner join
144631
How to bypass node_access when using EntityFieldQuery?
34287
How to populate owner name instead of id from a child object
124005
How to query records having at least one valid child record?
71937
Get the name of a row's source table when querying the parent it inherits from
115286
CAML Query of List's Lookup Field
158350
Programmatically get all names of an entity reference field
6011
How do I build a SOQL query for records in a list of IDs?
143526
How do I SOSL across objects, matching all records with FIND clause?
109032
Hidden fields though inheritance
141143
javascript get parent nested object?
40002
Autopopulate fields based on a lookup field value from a different object
51536
Concatenate fields in SOQL queries in the WHERE clause (no Apex)
132771
Junction object fields
21830
How to do joins in LINQ on multiple fields in single join
117165
Can SOSL retrieve child objects from the result set of parent objects?