Помогите с SQL запросом

[malex]

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