SQL JOINs make it easy to find and fix missing ... In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values ...