怎么根据已有的科目、客商、项目单独选出一条查出需要的数据，例如，选择场地租赁，显示的都是所有场地租赁的数据，但是我选了一个，报错，列名无效，另外这三个是和部门联动的

select 科目,客商,项目,sum((case when  表='T1' then 预收 else 0 end ) ) 预收,sum((case when 表='T1' then 冲销 else 0 end )) 冲销,

sum((case when 表='T2' then 预收 else 0 end ) ) 赊销,

sum((case when 表='T2' then 冲销 else 0 end ) ) 收款

 from 

( select 'T1' 表,科目,客商,项目,yskje 预收,cxje 冲销 from (

   select (select name  from uf_bd_account where uf_bd_account.id=d.km) 科目,

   (select name  from uf_bd_cust_supplier where uf_bd_cust_supplier.id=d.khmc) 客商,

   (select project_name  from uf_bd_project where uf_bd_project.id=d.xm) 项目,

    yskje,cxje  from uf_gl_voucher_dt1 d  where mainid in(select id from uf_gl_voucher where 1=1

${if(len(bumen) == 0,""," and orgcode in (" + bumen + ")")}

${if(len(starttime)=0,""," and prepareddate>='"+starttime+"'")}

${if(len(endtime)=0,""," and prepareddate<='"+endtime+"'")}  ))x

where 1=1

${if(len(km) == 0,""," and 科目 in (" + km + ")")}

${if(len(ks) == 0,""," and 客商 in (" + ks + ")")}

${if(len(xm) == 0,""," and 项目 in (" + xm + ")")}

union all

select 'T2',科目,客商,项目,sxje 赊销 ,skjine 收款  

from (

   select (select name  from uf_bd_account where uf_bd_account.id=d.kem) 科目,

   (select name  from uf_bd_cust_supplier where uf_bd_cust_supplier.id=d.keh) 客商,

   (select project_name  from uf_bd_project where uf_bd_project.id=d.xiangm) 项目,

    sxje,skjine  from uf_gl_voucher_dt2 d where mainid in(select id from uf_gl_voucher where 1=1

${if(len(bumen) == 0,""," and orgcode in (" + bumen + ")")}

${if(len(starttime)=0,""," and prepareddate>='"+starttime+"'")}

${if(len(endtime)=0,""," and prepareddate<='"+endtime+"'")} ))x

where 1=1

${if(len(km) == 0,""," and 科目 in (" + km + ")")}

${if(len(ks) == 0,""," and 客商 in (" + ks + ")")}

${if(len(xm) == 0,""," and 项目 in (" + xm + ")")}

)x

group by 科目,客商,项目

这是数据集