sql 同一个字段在查询结果中出现两次

SELECT

    GET .daytime,
    GET.data AS GET,
    xh.data AS xh
FROM
    ( SELECT daytime, SUM ( get_sum ) AS data FROM yuanbao_get GROUP BY daytime ORDER BY daytime ) AS GET,
    ( SELECT daytime, SUM ( xh_sum ) AS data FROM yuanbao_xh GROUP BY daytime ORDER BY daytime ) AS xh
WHERE
    GET.daytime = xh.daytime

posted @ 2019-03-04 13:45  巨象  阅读(1937)  评论(0)    收藏  举报