How to correctly compose an SQL query (JOIN)?

Question

PHP

There are 3 tables:
1) Main table with orders

2) Connecting table

3) Main table with goods

I fight with JOINs, it doesn't work. How to draw columns: product name (from 3 tables), quantity (1 table), cost (1 table)?

Answer 1

SELECT
  a.price, 
  a.count,
  c.name
FROM
  a
  LEFT JOIN b ON a.id_order = b.id_order
  LEFT JOIN c ON b.id_product = c.id_product

Answer 2

select
t3.name,
t1.count,
t1.price
from table1 t1
inner join table2 t2 on t2.id_order = t1.id_order
inner join table3 t3 on t3.id_product = t2.id_product