mysql - 如何将两个选定的列组合成一个表？

Question

我想从两个表中选择两列，然后将它们合并到一个表中，这两个表中没有相关列。我该怎么做？

例如:

表A:

NAME TAG
A     xx
B     xx
C     xx

表 B:

NAME TAG
D     yy
E     yy
F     yy

我想要一个像下面这样的输出表

xx yy
A  D
B  E
C  F

Answer 1

您似乎只想要一个垂直列表。如果是这样，您可以添加一个枚举列并按其分组:

select min(a_name), min(b_name)
from ((select row_number() over (order by name) as seqnum, name as a_name, null as b_name
       from a
      ) union all
      (select row_number() over (order by name) as seqnum, null, name
       from b
      )
     ) ab
group by seqnum;