php - 如何发送查询以获取两个表的总和？

Question

我想得到两张表的总和。

1-1.hospital_payment_data 表

1-2.hospital_payment_data表数据

2-1.advenced_pa​​yment 表

2-2 advenced_pa​​yment 表数据

我要结果

但是，发送查询结果如下。

SELECT  COUNT(IF(treatment_fees_check_division = '선수금',
                        treatment_fees_check_division, NULL)) AS COUNT,
        SUM(CASE WHEN treatment_fees_check_division = '선수금'
                   THEN treatment_fees_difference END) + SUM(advenced_amount
             ) AS if_treatment_fees_check_division,
        SUM(advenced_amount) AS sum_init_amount
    FROM  
    (
        SELECT  treatment_fees_check_division, treatment_fees_difference,
                init_amount, advenced_amount
            FROM  hospital_payment_data , advenced_payment 
    )AS a 

结果不好

如何修复查询？我想要你的姿势，拜托。

标签： phpmysqlsqlmariadb

Answer 1

这是你想要的？

SELECT ( SELECT SUM(...) FROM t1 ... ) +
       ( SELECT SUM(...) FROM t2 ... )  AS sum_of_tables