SQL合并两个结果集 [英] Sql Merging two result sets

问题描述

让我们采用两个结果集，如:1,2,3,5,7和2,4,6,7,8

Lets take two result sets as in: 1,2,3,5,7 and 2,4,6,7,8

最后我要1,2,3,4,5,6,7,8.我不知道如何在sql中编写代码.有人可以给我一些建议吗?我已经看到了一些合并功能，但是在实现简单的东西时遇到了麻烦.

In the end I want 1,2,3,4,5,6,7,8. I can not figure out how to code this in sql. Can any one give me some suggestions? I've seen some merging functions out there but having trouble implementing something simple.

推荐答案

我认为您可能正在考虑UNION?

I think maybe you're thinking of UNION?

如果SELECT `Column` FROM `Table`产生1,2,3,5,7

SELECT `Column` FROM `Table2`产生2,4,6,7,8

然后

SELECT `Column` FROM `Table`
UNION
SELECT `Column` FROM `Table2`

产量1,2,3,4,5,6,7,8

这篇关于SQL合并两个结果集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！