So...

I have 3 tables:

TABLE: Sales
Attributes: Sale_id, employee_id, customer_id, date_sale, amount, quantity

TABLE: Products
Attributes: They're too many. Let's consider just product_id, product_name

TABLE: Gets (it's actually a relationship between Sales and Products)
Attributes: sale_id, product_id, qantity



I'm making a query in Sales that shows, among other stuff, the actual NAME of the product that is being sold... I managed to show the employee and customer names, but not the product_name, because I don't have any product_id in Sales table, I don't know how to relate them.

This is what I have so far, showing everything I need, except for the product_name.

select
sales.data_sale as "Date",
a.person_name as "Employee",
b.person_name as "Client",
sales.quantity as "Quantity",
sales.amount as "Total (€)"
from person a, person b, sales
where sales.employee_id = a.person_id and sales.customer_id = b.person_id

Any help please? It's kind of urgent...