Say I have 2 tables with exactly SAME number of rows, but no other obvious relations:
tableA
ID | items |
---|---|
1 | banana |
2 | orange |
tableB
itemID | volume |
---|---|
5550 | 50 |
5551 | 70 |
Can I join these 2 tables horizontally, to form 1 table like the following?
ID | items | itemID | volume |
---|---|---|---|
1 | banana | 5550 | 50 |
2 | orange | 5551 | 70 |
try this