Rookie's question: How to combine two tables horizontally# Database - 数据库
M*7
1 楼
Hi all. I am a rookie of SQL. Here is my question:
table 1:
number name
1 A
2 B
3 C
table 2:
city zip
AA 01
BB 02
CC 03
the two tables are not related at all. How could I use SELECT to get the
table 3 as below
table 3:
number name city zip
1 A AA 01
2 B BB 02
3 C CC 03
Thanks a lot.
table 1:
number name
1 A
2 B
3 C
table 2:
city zip
AA 01
BB 02
CC 03
the two tables are not related at all. How could I use SELECT to get the
table 3 as below
table 3:
number name city zip
1 A AA 01
2 B BB 02
3 C CC 03
Thanks a lot.