INNER JOIN

1 photo

creates a new result table by combining column values of two or more tables, there must be at least some matching data between tables that are being compared by condition.