如何将三段sql语句存到一个结果集中返回？

Question

这是我的SQL语句：

             select
                                    a.amount as suixi_money,
                                    a.amodanaTime as suixi_tiem,
                                    a.registerMobile as principal_tel_number,
                                    b.type as activity_type,
                                    c.name as query_nickname,
                                    c.mobile as query_tel_number,
                                    c.realName as query_name
                               from tb_activity_record a
                                left join tb_activity b on a.activityId = b.id
                                left join tb_member c on a.memberId = c.id
                        where 1=1
                                and b.uid = '8445e6a4-9341-455b-bfef-81e0b5ed7a1e'
                                and  (
                                c.name like '1%'
                                or c.realName like '1%'
                                or c.mobile like '1%'
                                 )

                            select count(*) from (select distinct memberId from tb_activity_record ) ac


                            select SUM(amount) from tb_activity_record

这三段：

万分感谢

Answer 1

 SELECT
    A .amount AS suixi_money,
    A .amodanaTime AS suixi_tiem,
    A .registerMobile AS principal_tel_number,
    b. TYPE AS activity_type,
    c. NAME AS query_nickname,
    c.mobile AS query_tel_number,
    c.realName AS query_name,
ac.count,
su.SUM
FROM
(select count(*) count from (select distinct memberId from tb_activity_record ) d) ac,
(select SUM(amount)  SUM from tb_activity_record) su,
    tb_activity_record A
LEFT JOIN tb_activity b ON A .activityId = b. ID
LEFT JOIN tb_member c ON A .memberId = c. ID

WHERE
    1 = 1
AND b. UID = '8445e6a4-9341-455b-bfef-81e0b5ed7a1e'
AND (
    c. NAME LIKE '1%'
    OR c.realName LIKE '1%'
    OR c.mobile LIKE '1%'
)

你第一段sql查不出数据啊？