--比较简单吧,没环境测试,你试试呢? select a.fid,a.FSmpNum,a.FsmpName, decode(a.FAuditStatus,10,to_char(add_months(b.FBegDate,-1),'yyyymm'),20,to_char(b.FBegDate,'yyyymm')) FcmpPeriodNumber, decode(a.FAuditStatus,10,to_char(add_months(b.FEndDate,-1),'yyyymm'),20,to_char(b.FEndDate,'yyyymm')) FcmpPeriodName from T_HR_SmpDB a,T_HR_Period b where a.FperiodID=b.Fid
--比较简单吧,没环境测试,你试试呢?
select a.fid,a.FSmpNum,a.FsmpName,
decode(a.FAuditStatus,10,to_char(add_months(b.FBegDate,-1),'yyyymm'),20,to_char(b.FBegDate,'yyyymm')) FcmpPeriodNumber,
decode(a.FAuditStatus,10,to_char(add_months(b.FEndDate,-1),'yyyymm'),20,to_char(b.FEndDate,'yyyymm')) FcmpPeriodName
from T_HR_SmpDB a,T_HR_Period b
where a.FperiodID=b.Fid