Final answer:
The statement is true; an inner join is indeed a join that shows only the matching rows from the joined tables in the results.
Step-by-step explanation:
The statement 'Joins that show only matching rows from the joined tables in their results are called inner joins' is true. An inner join is a type of join in SQL that combines rows from two or more tables based on a related column between them. It only includes the rows that have matching values in both tables. If there is no match, the result set will not include rows from either table. For example, if you have two tables, one with employee information and another with department information, an inner join will yield a result set that contains only the employees who are assigned to departments. This means if an employee does not belong to any department or if a department does not have any employees, this information will not appear in the results of an inner join.