What is all the product data, as well as  each product's manufacturer?
select * from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code