用case when咯

----

SELECT A.ACCOUNTCODE,A.PERIODV,A.NOV,A.YEARV,A.LOCALCREDITAMOUNT,A.LOCALDEBITAMOUNT,A.EXPLANATION,A.PK_VOUCHERTYPEV,A.ASSID,A.PK_DETAIL,A.PK_ACCOUNTINGBOOK,A.PK_ORG,A.PK_ACCASOA,

 B.NAME AS 财务组织,

 C.NAME AS 凭证类别,

 D.FILE_ID AS 数据交换平台传递编号,F.NAME as 收支项目,G.NAME as 部门辅助,H.NAME as 预算机构,I.NAME AS 机型辅助,

 case when I.NAME in ('A320-200','A319-200') then '客机' else '货机' end as 机型,

 case when length(nvl(D.FILE_ID,''))=16 then '成本结算系统传递' else '收入结算系统传递' end  as 系统

FROM GL_DETAIL A

LEFT JOIN (SELECT B.PK_CORP,B.NAME FROM ORG_CORP B WHERE B.NAME='A公司')B ON B.PK_CORP=A.PK_ORG

LEFT JOIN (SELECT C.PK_VOUCHERTYPE,C.NAME from  BD_VOUCHERTYPE C )C ON C.PK_VOUCHERTYPE=A.PK_VOUCHERTYPEV

LEFT JOIN (SELECT D.PK_DETAIL,D.FILE_ID from V_GL_DETAIL D)D ON D.PK_DETAIL= A.PK_DETAIL

LEFT JOIN  GL_DOCFREE1 E on  A.ASSID=E.ASSID 

LEFT JOIN  BD_INOUTBUSICLASS F ON  E.F8=F.PK_INOUTBUSICLASS

LEFT JOIN  ORG_DEPT  G ON  E.F1=G.PK_DEPT

LEFT JOIN  ORG_DEPT  H ON  E.F26=H.PK_DEPT

LEFT JOIN  BD_DEFDOC  I ON  E.F22=I.PK_DEFDOC

WHERE  YEARV='2022' and PERIODV='09' and NOV='95' AND  C.NAME='成本凭证'

外嵌一层 SQL 呗

例如

SELECT A.*,(CASE WHEN ACCOUNTCODE='XXXX' THEN  'jjjj' WHEN ACCOUNTCODE='ttt' THEN  'ppp' ELSE ACCOUNTCODE END)  AS 'NEW' FROM (现在的SQL) A