| 123456789101112131415161718192021 |
- SELECT t3.sa_saleareaid,
- sum(ROUND(m1 * price, 2)) m1amount,
- sum(ROUND(m2 * price, 2)) m2amount,
- sum(ROUND(m3 * price, 2)) m3amount,
- sum(ROUND(m4 * price, 2)) m4amount,
- sum(ROUND(m5 * price, 2)) m5amount,
- sum(ROUND(m6 * price, 2)) m6amount,
- sum(ROUND(m7 * price, 2)) m7amount,
- sum(ROUND(m8 * price, 2)) m8amount,
- sum(ROUND(m9 * price, 2)) m9amount,
- sum(ROUND(m10 * price, 2)) m10amount,
- sum(ROUND(m11 * price, 2)) m11amount,
- sum(ROUND(m12 * price, 2)) m12amount
- from sa_salestargetbill t1
- INNER JOIN sa_salestarget t2 ON t2.sa_salestargetbillid = t1.sa_salestargetbillid
- INNER JOIN sa_customers t3 on t3.sa_customersid=t1.sa_customersid
- WHERE t1.year = $year$
- and t1.`status` = '审核'
- and t1.siteid = $siteid$
- and t1.sa_customersid>0
- GROUP BY t3.sa_saleareaid
|
