What is the result of an INNER JOIN between table1 and table2?
INNER JOIN
No records from table1 are ever displayed.
Only records that have no corresponding records in table1 or table2 are displayed.
All records from table1 are displayed, regardless of whether the records have a corresponding row in table2
Only records that have corresponding entries in table1 and table2 are displayed.