select TSteelLevel.Symbol,b.* from
(
select '',gajjb,trim(cstr(zj)) as jbzj,gajjb+tj as typ,
sum(bangaj)/1000 as bangaj1,
sum((zhugaj ))/1000 as zhugaj1,
sum( gouzzgaj)/1000 as gzzgaj1,
sum((lianggaj))/1000 as lianggaj1,
sum(quanlgaj)/1000 as quanlgaj1,
sum(guolgaj)/1000 as guolgaj1,
sum(qianggaj-qtjgaj)/1000 as qianggaj1,
sum(anz)/1000 as anz1,
sum(anl) /1000 as anl1,
sum(jicgaj)/1000 as jicgaj1,
sum(lout)/1000 as lout1,
sum(qit)/1000 as qit1 ,
sum(qtjgaj)/1000 as qtljj ,
sum(gajzz)/1000 as gajzz1,
sum(zhuangjigaj)/1000 as zhuangji,
sum(steelmeasure)/1000 as measure
from [].TGAJHZTMP
group by zj,gajjb, '',gajjb+tj
order by gajjb+tj
) b, TSteelLevel
where b.gajjb=TSteelLevel.Alpha
order by typ
select TSteelLevel.Symbol,b.* 这个 查询的是两个?TSteelLevel.Symbol和b.*;
b.*是不是指b表格的所有字段?
|