CREATE TABLE Manufacturers (code VARCHAR2)
CREATE TABLE products (manufacturer VARCHAR2)

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" "T1" JOIN "Manufacturers" "T2" ON "T1"."manufacturer" = "T2"."code"