mysql 多表查询

#查询两个表中的字段其中金额汇总，然后并加条件，然后分组并排序方法

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