How to form a many to many SQL query?

Question

SQL

Help to form a many to many query: you need to get the name of the product, the quantity and amount of the order (cheque table).

There are 3 tables:

• product: id, name, price
  
• sale: id, date, sum_sale
  
• check: id_sale, id_product, count_product
  

Answer 1

So far I've found this solution:

SELECT
    p.name,
    c.count_product,
    p.price,
    s.sum_sale,
    s.date
FROM
    product AS p
INNER JOIN cheque AS c
ON
    p.id = c.id_product
INNER JOIN sale AS s
ON
    s.id = c.id_sale

Answer 2

JOIN