124124

最新推荐文章于 2024-08-31 01:08:50 发布

invictusleec

最新推荐文章于 2024-08-31 01:08:50 发布

阅读量192

点赞数

本文链接：https://blog.csdn.net/invictusleec/article/details/106135306

版权

SELECT
  table01.CONTRACT_NO,
  ( table01.cpcauto+table03.extaum) AS TOTAL_AMOUNT
FROM (SELECT
        tc01.CONTRACT_NO,
        tc01.CONTRACT_ID,
        (SELECT
           SUM(PRICE*CNUMBER)
         FROM contract_product_c pc01
         WHERE pc01.CONTRACT_ID = tc01.CONTRACT_ID) AS cpcauto
      FROM contract_c tc01) AS table01,
  (SELECT
     table02.CONTRACT_ID,
     IFNULL(SUM(extaum),'0') AS extaum
   FROM (SELECT
           cpc02.CONTRACT_ID,
           (SELECT
              SUM(PRICE*CNUMBER)
            FROM ext_cproduct_c et02
            WHERE et02.CONTRACT_PRODUCT_ID = cpc02.CONTRACT_PRODUCT_ID) AS extaum
         FROM contract_product_c cpc02
         GROUP BY cpc02.CONTRACT_PRODUCT_ID) AS table02
   GROUP BY table02.CONTRACT_ID) AS table03
WHERE table01.CONTRACT_ID = table03.CONTRACT_ID