Inner Join

A join of two or more tables that returns only the matched rows is called an inner join

SELECT sales.sales_date, sales.order_id, sales.product_id, product.product_name
FROM sales INNER JOIN product
ON sales.product_id = product.product_id;