select ID,BH,e.dictmean as BM,SPBM,d.dictmean
as MZ,DZMZ,YE,SITES,SITE_LY,SITE_HS,to_char(FQRQ,'yyyy-mm-dd') as FQRQ,to_char(HSRQ,'yyyy-mm-dd') as HSRQ,f.dictmean as FLAG
from INTO_COUPONS c ,
sys_dict2 d,
sys_dict2 e,
sys_dict2 f where
(c.mz = d.dictno and d.mainno = 3042)
and (c.bm = e.dictno and e.mainno = 3046)
and (c.bm = f.dictno and f.mainno = 3047)
oracle 数据字典
最新推荐文章于 2022-02-25 20:00:37 发布