hql语句:select a.id.xm,a.id.xb,a.id.zjh,a.id.qs,a.id.pxcxhlb,a.id.xybh as xybh,sum(case b.id.pxkm when '1' then b.id.yxsc else 0 end) as km1yxsc,sum(case b.id.pxkm when '1' then b.id.pxsc else 0 end) as km1pxsc,sum(case b.id.pxkm when '1' then decimal(b.id.yxlc,10,2) else 0 end) as km1yxlc,sum(case b.id.pxkm when '2' then b.id.yxsc else 0 end) as km2yxsc,sum(case b.id.pxkm when '2' then b.id.pxsc else 0 end) as km2pxsc,sum(case b.id.pxkm when '2' then decimal(b.id.yxlc,10,2) else 0 end) as km2yxlc,sum(case b.id.pxkm when '3' then b.id.yxsc else 0 end) as km3yxsc,sum(case b.id.pxkm when '3' then b.id.pxsc else 0 end) as km3pxsc,sum(case b.id.pxkm when '3' then decimal(b.id.yxlc,10,2) else 0 end) as km3yxlc from TXysqxxb a,TPxjlzsb520400 b where a.id.xybh=b.id.xybh AND a.id.pxjgmc = '230900001' group by a.id.xybh,a.id.xm,a.id.xb,a.id.zjh,a.id.qs,a.id.pxcxhlb order by (a.id.xm) asc with ur
hql语句:select a.id.xm,a.id.xb,a.id.zjh,a.id.qs,a