The query editor window allows you to define the relationship between queries and view SQL code resulting from the joins you create.
Join Properties
SQL
Creating Data Access Logic
Adding Joins to a Query