I am trying to get all the products from the
company ON products.company_id = company.company_id
It seems you have an optional relationship here, so use
.... FROM Products LEFT JOIN Company ON Products.Company_Id = Company.Company_Id
This retrieves all the products whether linked to a valid company or not.
I think you also need to go over your data and check if you have your foreign keys set up right and have the correct data.