select
a.TypeNo,
'is'||SUBSTR(a.TypeNo,1,1) as Type,
a.DocNo,
DECODE(NVL(a.DocNo,0),0,'No','Yes') as HasDocNo
b.Date
from
表1 a,
表2 b
where
a.TypeNo=b.TypeNo
a.TypeNo,
'is'||SUBSTR(a.TypeNo,1,1) as Type,
a.DocNo,
DECODE(NVL(a.DocNo,0),0,'No','Yes') as HasDocNo
b.Date
from
表1 a,
表2 b
where
a.TypeNo=b.TypeNo
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货