Hi,

What table joins can I use to find all products in a given category?
I initially thought that master_categories_id on the products table would be it, but when I query the table as

SELECT * FROM products_description where master_categories_id = 100

it throws the error

Error: Unknown column 'master_categories_id' in 'where clause'
SQLState: 42S22
ErrorCode: 1054

I know SQL but not a MySQL guy, so not sure how to use that column. Appreciate any tips!