Выборка полей из разных таблиц

[mazzy]

  select  sum(CostAmount)
      from inventJournalTrans
  join sum(CostAmountPosted) from invenTrans
      where inventJournalTrans.ItemId==invenTrans.ItemId &&
      inventJournalTrans.voucher==invenTrans.voucher;