SELECT p.*, c.description, s.company_name
from products p
join categories c on p.category_id = c.category_id
Join suppliers s on p.supplier_id = s.supplier_id

I tried above in https://www.sql-practice.com/ this way u can do it, but plz post your schema to understand the issue you are facing