Q&A
When joining tables, must they be joined in the same order that they appear in the FROM clause?
No, they do not have to appear in the same order; however, performance benefits may be experienced depending on the order of tables in the FROM clause and the order that tables are joined.
When using a BASE TABLE to join unrelated tables, must I select any columns from the base table?
No, the use of a BASE TABLE to join unrelated tables does not mandate columns for selection from the base table.
Can I join on more than one column between tables?
Yes, some queries may require you to join on more than one column per table to provide a complete relationship between rows of data in the joined tables.