Listen

When querying two tables, using an INNER JOIN to link them will retrieve:

All rows in all joined tables are included, whether they are matched or not.

Only the rows that have a match in both joined tables.

All rows from the first$-$named table $($the "left" table, which appears leftmost in the JOIN clause$)$ are included.

All rows in the second$-$named table $($the "right" table, which appears rightmost in the JOIN clause$)$ are included.