while select InventSum where InventSum.AvailPhysical > 0 /* dimension criteria */ #InventDimJoin(InventSum.inventDimId,inventDimSum,inventDimCriteria,InventDimParm) { }