一条DB2 SQL

最新推荐文章于 2021-02-07 12:29:40 发布

不止鱼

最新推荐文章于 2021-02-07 12:29:40 发布

阅读量904

点赞数

分类专栏：存储与DB

本文链接：https://blog.csdn.net/robert_lizhiqiang/article/details/41082711

版权

存储与DB 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

SELECT MERID, MERNAME, GOODSID, GOODSNAME, BANKNAME, SUM(AMOUNT) AS TOTALAMOUNT
  FROM
       (SELECT T.*, BANK.BANKNAME, GOODS.GOODSNAME, MER.MERNAME
          FROM
               UMPAY.T_UPTRANS_1411 AS T LEFT OUTER JOIN UMPAY.T_BANK_INF AS BANK ON BANK.BANKID = T.BANKID LEFT OUTER JOIN UMPAY.T_GOODS_INF AS GOODS ON GOODS.GOODSID = T.GOODSID AND GOODS.MERID = T.MERID LEFT OUTER JOIN UMPAY.T_MER_INF AS MER ON T.MERID = MER.MERID) AS PRIM
  GROUP BY MERID, MERNAME, GOODSID, GOODSNAME, BANKNAME

一条DB2 SQL

select prim.MERID,prim.MERNAME,prim.GOODSID,prim.GOODSNAME,prim.BANKNAME,SUM(prim.AMOUNT) TOTALAMOUNT from (select t.*,bank.BANKNAME,goods.GOODSNAME,mer.MERNAME from UMPAY.T_UPTRANS_1411 as t left join UMPAY.T_BANK_INF as bank on bank.BANKID=t.BANKID left join UMPAY.T_GOODS_INF goods on goods.GOODSID=t.GOODSID and goods.MERID=t.MERID left join UMPAY.T_MER_INF as mer on t.MERID=mer.MERID) prim group by prim.MERID,prim.MERNAME,prim.GOODSID,prim.GOODSNAME,prim.BANKNAME