如何使两个查询的结果（同一列）从两个查询显示在单个查询表中

Question

我不知道我是否可以理解我的问题， 情况如下： 我有两个查询，它们有同样要求显示面板ID和剩余点数，但其中一个是针对仍然获得2000分的客户，一个是针对已经兑换一次的客户，我在下面写出了两个查询。

1）

select panel_ID,current_points_balance, sum(points_earned) as totalpoint 
from Tbl_member, Tbl_member_participation 
where tbl_member_participation.member_id = Tbl_member.member_id 
group panel_Id, current_points_balance 
having totalpoint > 2000 

2）

select panel_ID,current_points_balance, sum(points_earned) as totalpoint 
from Tbl_member, Tbl_member_redemption 
where tbl_member_redemption.member_id = Tbl_member.member_id 
group panel_Id, current_points_balance 

所以我的问题是我怎么能在一个查询中合并这两个条件或只显示来自两个查询的两个结果在一个表中？我不认为我可以简单地用“或”来组合它们，但这是我知道的唯一方法。

Answer 1

关键字UNION和UNION ALL用于连接来自两个查询的结果与SAME NO OF COLUMNS。在query.not

使用UNION语句确保您database.But以下工作是否给一个尝试，如果你想将这些查询的结果，结合我的评论在任何问题上

select panel_ID,current_points_balance, sum(points_earned) as totalpoint 
from Tbl_member, Tbl_member_participation 
where tbl_member_participation.member_id = Tbl_member.member_id 
group panel_Id, current_points_balance 
having totalpoint > 2000 
UNION 
select panel_ID,current_points_balance, sum(points_earned) as totalpoint 
from Tbl_member, Tbl_member_redemption 
where tbl_member_redemption.member_id = Tbl_member.member_id 
group panel_Id, current_points_balance 

Answer 2

一个单一的视图，我的意思是你有两个colums panel_ID，current_points_balance你想显示两个查询的结果在同一列本身，然后用UNION，UNION ALL

select 
    panel_ID, current_points_balance, 
    sum(points_earned) as totalpoint 
from 
    Tbl_member, Tbl_member_participation 
where 
    tbl_member_participation.member_id = Tbl_member.member_id 
group 
    panel_Id, current_points_balance 
having 
    totalpoint > 2000 

UNION 

select 
    panel_ID,current_points_balance, 
    sum(points_earned) as totalpoint 
from 
    Tbl_member, Tbl_member_redemption 
where 
    tbl_member_redemption.member_id = Tbl_member.member_id 
group 
    panel_Id, current_points_balance 

或者你可以使用

select 
    panel_ID,current_points_balance, 
    sum(points_earned) as totalpoint 
from 
    Tbl_member, Tbl_member_participation 
where 
    tbl_member_participation.member_id = Tbl_member.member_id 
group 
    panel_Id, current_points_balance 
having 
    totalpoint > 2000 

UNION ALL 

select 
    panel_ID,current_points_balance, 
    sum(points_earned) as totalpoint 
from 
    Tbl_member, Tbl_member_redemption 
where 
    tbl_member_redemption.member_id = Tbl_member.member_id 
group 
    panel_Id, current_points_balance 

UNION和UNION ALL之间的区别是什么，但联盟将消除所有重复的行和工会都不会消除重复行

试试这个，如果有问题与此