本文共 1036 字，大约阅读时间需要 3 分钟。
selecto.ORDERTABLE,o.TRADENO,o.ORDERID,o.ORDERDATE,o.MERID,o.BUSIID,o.INNERSEQ,o.EXPIRETIME,o.BANKTYPE,o.BANKID,o.ACCOUNTTYPE,o.GATEID,o.ORDERSTATE,o.ACCESSTYPE,o.GOODSID...
select o.ORDERTABLE,o.TRADENO,o.ORDERID,o.ORDERDATE,o.MERID,o.BUSIID,o.INNERSEQ,o.EXPIRETIME,o.BANKTYPE,o.BANKID,
o.ACCOUNTTYPE,o.GATEID,o.ORDERSTATE,o.ACCESSTYPE,o.GOODSID,o.AMOUNT,o.ORIGAMT,o.AMTTYPE,
decode(nvl(c.REFUNDTIMES,0), 0,o.REFUNDTIMES,c.REFUNDTIMES) as REFUNDTIMES,
decode(nvl(c.refundamt,0), 0,o.refundamt,c.refundamt) as refundamt,
decode(nvl(c.splitTotalNum,0), 0,o.splitTotalNum,c.splitTotalNum) as splitTotalNum,
decode(nvl(c.splitedNum,0), 0,o.splitedNum,c.splitedNum) as splitedNum,
o.TRADEDESC,o.TRACE,o.INSTID,o.PAYCOUNT,o.MERCUSTID,o.MEDIATYPE,o.MEDIAID,o.INTIME,o.MODTIME,o.ORDERSTATETIME,
o.PRODUCTID,o.PAYTYPE,o.SPLITSTATE,o.SPLITTYPE,o.ISSUINGBANK,o.FINISHAMOUNT,o.ORIGTRACE,o.AUTHEXPIRE,
o.TRANSTYPE,o.ORIGTRADENO,o.SPLITCATEGORY
from $tableName$ o left join $payOrderCtrlTableName$ c on o.tradeno=c.tradeno
请帮忙把这个sql转化成mysql语法的谢谢！
展开
转载地址：https://blog.csdn.net/weixin_33212263/article/details/113265528 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！
发表评论
最新留言
关于作者
