锐思数据库怎么两个字段组合查询

问题描述

精选答案

select t6.FItemID as 物料代码, t5.FPeriod as 期初取数期间, sum(t5.FBegQty) as 期初数据 from ICInvBal t5 inner join t_ICItem t6 on t6.FItemID=t5.FItemID where t5.FPeriod=9 and t5.FItemID=260 group by t6.FItemID,t5.FPeriod order by t5.FItemID