高分求一SQL语句的写法,详情请进,应使用变量
--select distinct g.fparent
Select e.fname , company.fdisplayname_l2,g.fname_l2 ,
case when g.fnumber='1001'then d1.f17
when g.fnumber='1001'then d1.f17
when g.fnumber='1002'then d1.f18
when g.fnumber='1003'then d1.f19
when g.fnumber='1004'then d1.f20
when g.fnumber='1005'then d1.f21
when g.fnumber='1006'then d1.f22
when g.fnumber='1007'then d1.f23
when g.fnumber='1008'then d1.f24
when g.fnumber='1009'then d1.f17
when g.fnumber='1010'then d1.f18
when g.fnumber='1011'then d1.f19
when g.fnumber='1012'then d1.f20
when g.fnumber='1012'then d1.f21
when g.fnumber='1013'then d1.f22
end as Famount
From T_Csl_ItemData H,
T_Csl_ItemDataEntry D,
T_Csl_ItemDataEntry001 D1,
T_Org_BaseUnit Company,
T_Bd_Currency Cy,
T_Csl_CslReport e,
T_CSL_TempletItemList f,
t_csl_rptitem g
where H.FID=D.FItemDataID
and D.FID=D1.FID
and H.FCompanyID=company.Fid
and H.FCurrencyID=Cy.Fid
and h.freportid=e.fid
and e.ftemplateid=f.ftemplateid
and f.fitemnumber=g.fnumber
and e.fname ='资产负债表'
--and D.FDataElement=2 --本期发生数
--and D.FValueType=1 --金额