axm2013

select sum(..) from inventSum
group by ItemId,
where ...
exists join inventDim
where inventDim.inventDimId == inventSum.InventDimId
exists join wmsPallet
where...

?