摘要：
SELECT SVP.ENPGSCD,tem.dsnm,tem.dsfnm,pj.ennm,PJ.DSCD,SSFA.YR,SVP.DOCCD,SSFA.ENNMCD,SSFA.IRENNMCD,SSFA.IRENNM,SSFA.FSBSTRPCD,TO_CHAR(SVP.CTDT,'yyyy-mm-dd') as CTDT,SVP.STATUS//省略部分没用信息FROM(TBP1869_SVWTIRIMPLPG_044 SSFA LEFT OUTER JOIN TBP1870_SVWTIRENPGS_044 svp ON ssfa.ennmcd=svp.ennmcd)LEF 阅读全文
