This kind of query, in which results contain only records that contain matching values in both tables, is known as an INNER JOIN. To use the INNER JOIN syntax, you’d rewrite the query like this ...

Inner joins can be performed on up to 16 tables at a time, whereas outer joins (left, right, full) work on only two tables at a time. Joining Tables Manually If tables selected for joining have a ...