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 <table_name> : Manufacturers col : Code | Name | Headquarter | Founder | Revenue row 1 : 1 | Sony | Tokyo | Andy | 120 row 2 : 2 | Creative Labs | Austin | Owen | 100 row 3 : 3 | Hewlett-Packard | Los Angeles | James | 50 row 4 : 4 | Iomega | Beijing | Mary | 200 row 5 : 5 | Fujitsu | Taiwan | John | 130 row 6 : 6 | Winchester | Paris | Robert | 30 <table_name> : Products col : Code | Name | Price | Manufacturer row 1 : 1 | Hard drive | 240 | 5 row 2 : 2 | Memory | 120 | 6 row 3 : 3 | ZIP drive | 150 | 4 row 4 : 4 | Floppy disk | 5 | 6 row 5 : 5 | Monitor | 240 | 1 row 6 : 6 | DVD drive | 180 | 2 row 7 : 7 | CD drive | 90 | 2 row 8 : 8 | Printer | 270 | 3 row 9 : 9 | Toner cartridge | 66 | 3 row 10 : 10 | DVD burner | 180 | 2 row 11 : 11 | DVD drive | 150 | 3
col : Code -1 | Name -1 | Price | Manufacturer | Code -2 | Name -2 | Headquarter | Founder | Revenue row 1 : 1 | Hard drive | 240 | 5 | 5 | Fujitsu | Taiwan | John | 130 row 2 : 2 | Memory | 120 | 6 | 6 | Winchester | Paris | Robert | 30 row 3 : 3 | ZIP drive | 150 | 4 | 4 | Iomega | Beijing | Mary | 200 row 4 : 4 | Floppy disk | 5 | 6 | 6 | Winchester | Paris | Robert | 30 row 5 : 5 | Monitor | 240 | 1 | 1 | Sony | Tokyo | Andy | 120 row 6 : 6 | DVD drive | 180 | 2 | 2 | Creative Labs | Austin | Owen | 100 row 7 : 7 | CD drive | 90 | 2 | 2 | Creative Labs | Austin | Owen | 100 row 8 : 8 | Printer | 270 | 3 | 3 | Hewlett-Packard | Los Angeles | James | 50 row 9 : 9 | Toner cartridge | 66 | 3 | 3 | Hewlett-Packard | Los Angeles | James | 50 row 10 : 10 | DVD burner | 180 | 2 | 2 | Creative Labs | Austin | Owen | 100 row 11 : 11 | DVD drive | 150 | 3 | 3 | Hewlett-Packard | Los Angeles | James | 50