Write an SQL query utilizing an inner join to fetch matching records from two tables based on a specific scenario.
