在字段里的子查询语句

在select显示列中嵌入select

select arap_djzb.djbh 单据编号,
       arap_djfb.billdate   as 单据日期,
       bd_corp.unitname     as 付款单位,
       bd_cubasdoc.custcode as 收款单位编码,
       bd_cubasdoc.custname as 收款单位名称,
       bd_accbank.bankname,
       bd_accbank.bankacc   as 收款银行账号,
       arap_djfb.bbye       as 付款金额,
       arap_djfb.fkyhmc     as 付款银行名称,
       (select  bankacc from bd_accbank where pk_accbank=arap_djfb.fkyhzh)ZH,
       arap_djfb.zy         as 付款摘要,
       arap_djfb.payflag
  from bd_cubasdoc, arap_djfb, bd_cumandoc, arap_djzb, bd_corp, bd_accbank
where arap_djfb.ksbm_cl = bd_cumandoc.pk_cumandoc
   and bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc
   and arap_djfb.vouchid = arap_djzb.vouchid
   and bd_corp.pk_corp = arap_djzb.dwbm
   and bd_accbank.pk_accbank = arap_djfb.skyhzh
   and arap_djfb.payflag in ('1', '2')
   and arap_djfb.dr = '0'

select arap_djzb.djbh 单据编号,

arap_djfb.billdate as 单据日期,

bd_corp.unitname as 付款单位,

bd_cubasdoc.custcode as 收款单位编码,

bd_cubasdoc.custname as 收款单位名称,

bd_accbank.bankname,

bd_accbank.bankacc as 收款银行账号,

arap_djfb.bbye as 付款金额,

arap_djfb.fkyhmc as 付款银行名称,

(select bankacc from bd_accbank where pk_accbank=arap_djfb.fkyhzh)ZH,

arap_djfb.zy as 付款摘要,

arap_djfb.payflag

from bd_cubasdoc, arap_djfb, bd_cumandoc, arap_djzb, bd_corp, bd_accbank

where arap_djfb.ksbm_cl = bd_cumandoc.pk_cumandoc

and bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc

and arap_djfb.vouchid = arap_djzb.vouchid

and bd_corp.pk_corp = arap_djzb.dwbm

and bd_accbank.pk_accbank = arap_djfb.skyhzh

and arap_djfb.payflag in ('1', '2')

and arap_djfb.dr = '0'