#查询两个表中的字段其中金额汇总，然后并加条件，然后分组并排序方法 SELECT bir.saler_name, brd.remark, SUM(bir.amount) FROM bill_common_invoice_register bir, bill_common_register_dtl brd WHERE bir.bill_no = brd.bill_no and brd.remark=‘税控系统自动生成的发票登记‘ GROUP BY bir.saler_name desc
原文：https://www.cnblogs.com/onelove1/p/13215310.html