SQL JOINs make it easy to find and fix missing data Your email has ... will the new table contain? The answer depends on the WHERE clause. In this sample statement, the condition (table1.keyfield ...