SELECT * FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer  =  T2.code
Select all the data from the products and each product's manufacturer.
SELECT * FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer = T2.code
select * from products as t1 join manufacturers as t2 on t1 . manufacturer = t2 . code
Select all the data from the products and each product 's manufacturer .