How to Join InventSum and InventDim with group by InventLocationID ? February 25, 2012 While select InventSum Join InventDim where inventSum.InventDimId == InventDim.InventDimId && inventSum. inventLocationID == InventDim. inventLocationID Group By inventLocationID { write logic here for } Read more