PHP код:
while select inventTransGroup
group by InventTransId
where inventTransGroup.TransType == InventTransType::InventTransfer
join inventTransPosting
group by inventTransId, Account, AccountOffset, PostingType, PostingTypeOffset
where (inventTransPosting.InventTransId == inventTransGroup.InventTransId) &&
(inventTransPosting.InventTransPostingType == InventTransPostingType::Financial)
Действительно все получается.
Спасибо.