PHP код:
while select inventTransGroup
group by InventTransId
where inventTransGroup.TransType == InventTransType::InventTransfer
{
select inventTransPosting
where inventTransPosting.InventTransId == inventTransGroup.InventTransId &&
inventTransPosting.InventTransPostingType == InventTransPostingType::Financial;
// Some handle
}
Можно ли это сделать одним запросом ?
Например, как в MS SQL:
select distinct inventTrans.InventTransId, InventTransPosting.Account, InventTransPosting.AccountOffset
from inventTrans
join inventTransPosting on
(inventTransPosting.InventTransId = inventTrans.InventTransId) and
(inventTransPosting.InventTransPostingType = 1)
where inventTrans.TransType = 6