SELECT sales.sale_id, clients.client_name, items.item_name, sales.sale_date

FROM sales

JOIN clients ON sales.client_id = clients.client_id

JOIN items ON sales.item_id = items.item_id;