Преобразование вложенного SQL-запроса в query

[dech]

Если чекбоксы не нужны, можно сделать так:

select ItemId, InternalSP, sum(SPQty) from VendSPListTrans
    group by ItemId, InternalSP
join PurchId, sum(Qty) from VendInvoiceTrans
    group by PurchId
    where VendInvoiceTrans.InternalSP == VendSPListTrans.InternalSP
       && VendInvoiceTrans.ItemId == VendSPListTrans.ItemId
join SPDate, EmplId, IdSP from VendSPListJour
    group by SPDate, EmplId, IdSP
    where VendSPListJour.SPClosed == NoYes::No
exists join InventTableModule
    where InventTableModule.ItemId == VendSPListTrans.ItemId
       && InventTableModule.ModuleType == 1;