How to make a selection from three tables in SQL?

Question

SQL

I can not understand how to make a request to select three fields from three different tables of the same database.
In the attachment of a screenshot of the tables, you need to make a selection and show the names of goods, the names of subcategories and the names of categories.
Can you please tell me how to make a request?

Answer 1

select
t1.name_goods,
t2.name_subcat,
t3.name_cat
from goods t1
left join subcategory t2 on t2.id_subcat = t1.id_subcat
left join category t3 on t3.id_cat = t1.id_cat

Answer 2

Google towards JOIN. In this case INNER JOIN.

Answer 3

You have an indeterminacy: in categoryno subcategoryfor id_subcat (110, 111).
In goodstrimmed id_cator not divided into subcategories.
And it is possible without correction:

SELECT goods.name_goods, subcategory.name_subcat, category.name_cat
  FROM goods 
    LEFT OUTER JOIN category ON goods.id_cat = category.id 
    LEFT OUTER JOIN subcategory ON goods.id_cat = subcategory.id_subcat / 10