标签： left join

SELECT s.UNIT_UID AS supplierId, s.UNIT_NAME as supplierName, SUM(IFNULL(d.size, 0)) AS orderNum, SU … 继续阅读 left join