[Protey]

Необходимо написать такой запрос в Аксапте

select itemid, sum(postedQty + received - deducted + registered - picked) as QtySum from bmssa.inventsum
where 
inventdimid in (select inventdimid from bmssa.inventdim where inventlocationid = @location and dataareaid = 'rus') 
and dataareaid = 'rus'
and itemid='747642'
group by itemid

Подскажите, как сделать? без while select