SELECT SUM(jin),SUM(chu) FROM sysdbuil。转换成TP6的语句要怎么写

Question

SELECT SUM(jin),SUM(chu) FROM sysdbuil。转换成TP6的语句要怎么写

试过用

    $Db = Db::table('sysdbuil')->alias('a')
        ->leftJoin(['user' => 'b'], 'a.buil_id = b.id')
        ->sum('a.jin','a.chu');

这样只能查出jin的。

Answer 1

可以试试：

Db::table('sysdbuil')->alias('a')->leftJoin(['user' => 'b'], 'a.buil_id = b.id')->field('sum(a.jin), sum(a.chu)')->select();