Join Transitivity and Query Complexity

Utilize transitive properties of foreign key relationships to simplify join logic.