If the column appears only in one of the referenced tables, you don’t need to include the fully qualified name, but it may be useful to do so for readability. Must-read developer coverage ...

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.