Is it possible to join tables sequentially rather than having to join all secondary tables to the primary table (but not secondary tables to each other)?
For example join table 1 and 2. Then join table 3 to table 2 (so indirectly joined with table 1 but the join column for table 3 is only common with a column in table 2. Likewise table 1 and table 2 share a column but table 1 and table 3 don't share the same column).
I assume this could be done with the SQL code but just curious if there was a quick point and click method?