select * from(select to_number(to_CHAR(FBIZDATE,'yyyy')),FLOATT,FBIZDATE, FMATERIALID,CFTESTNUMBER,FCOSTCENTERORGUNITID,FCUSTOMERID,FDESCRIPTION,FQTY,FINQTY,FQTYBALANCE,REMARKS,FNUMBER FROM T_IM_BALANCE_QTY where to_number(to_CHAR(FBIZDATE,'yyyy')-1)='2021' and FMATERIALID='010104001802' UNION all select to_number(to_CHAR(FBIZDATE,'yyyy')),FLOATT,FBIZDATE, FMATERIALID,CFTESTNUMBER,FCOSTCENTERORGUNITID,FCUSTOMERID,FDESCRIPTION,FQTY,FINQTY,FQTYBALANCE,REMARKS,FNUMBER FROM T_IM_BALANCE_QTY where to_number(to_CHAR(FBIZDATE,'yyyy'))='2021' and FMATERIALID='010104001802') a ORDER BY FBIZDATE |