我想将两个查询的内容链接起来。请注意,我不想使用CONCAT()
或CONCAT_WS()
,因为这不是我想要实现的。
查询1结果:
Id Name
1 John
2 Mike
查询2结果:
Id Name
3 Emily
7 Robert
我想要的是:
Id Name
1 John
2 Mike
3 Emily
7 Robert
我还可以将两个查询重写为一个查询。那太好了。以下是我当前失败的尝试:
SELECT a.x AS x, a.y AS y FROM a;
SELECT b.x AS x, b.y AS y FROM b;
谢谢。
使用UNION ALL
将多个查询连接到一个结果集:
SELECT a.x AS x, a.y AS y FROM a
UNION ALL
SELECT b.x AS x, b.y AS y FROM b
注意
UNION ALL
将保留所有冗余。请阅读手册页面并修改查询以实现您想要的行为。
SELECT a.x AS x, a.y AS y FROM a
union all
SELECT b.x AS x, b.y AS y FROM b;
使用UNION
:
SELECT a.x AS x, a.y AS y FROM a
UNION ALL
SELECT b.x AS x, b.y AS y FROM b;
使用并集怎么样?
SELECT a.x AS x, a.y AS y
FROM a
UNION
SELECT b.x AS x, b.y AS y
FROM b;
您似乎想要一个联合:
SELECT a.x AS x, a.y AS y FROM a
UNION
SELECT b.x AS x, b.y AS y FROM b
如果希望保留可能的冗余,请使用UNION ALL。