mysql - mysql中如何合并多个表

Question

如何将不同列名的多个表合并到一个表中？

我有表1和表2，所以我想将表2的字段合并到表1中。

例如:

表一

ID NAME
1  A
2  B
3  C

表2

SEX Address
M   A
F   B
M   C

我需要的结果如下:

结果

ID NAME SEX  ADDRESS
1  A    M    A
2  B    F    B
3  C    M    C

如何在 mysql 中做到这一点？

Answer 1

Here is the SQLFiddel working Demo

以下是您可以尝试的查询

select T1.ID,T1.Name,T2.Sex,T2.Address
  from 
(select *,@Row1 := @Row1 + 1 as rownum
  from Table1
  join (select @Row1 := 0) r) as T1
join
(select *,@Row2 := @Row2 + 1 as rownum
  from Table2
  join (select @Row2 := 0) r) as T2
Where T1.rownum = T2.rownum