嵌套查询
求和
select
(select sum(XLWeigh) from WeighDiao
where WsType='线材') as XCXLSum,
(select sum(XLWeigh) from WeighDiao
where WsType='棒材') as BCXLSum
(select sum(XLWeigh) from WeighDiao
where WsType='线材') as XCXLSum,
(select sum(XLWeigh) from WeighDiao
where WsType='棒材') as BCXLSum