SELECT SUM(game_equipment_sales),
  SUM(repair_under_contract),
  SUM(other_incomes)
 FROM  ind_dep_incomes
 WHERE (Ind_dep_incomes.mode_id =  1 ) AND (ind_dep_incomes.main_id=:incomes_id)

SELECT Industrial_department.incomes_id,
  Industrial_department.charges_on_manufacture_id,
  Industrial_department.invested_means_id,
  Industrial_department.firm_charges_id, Industrial_department.date,
  Industrial_department.coment, Industrial_department.other_incomes,
  Industrial_department.other_charges_on_manufacture,
  Industrial_department.other_invested_means,
  Industrial_department.other_firm_charges_id,
  Industrial_department.other_firm_fields,
  Industrial_department.ind_dep_id, Industrial_department.rep_date,
  Industrial_department.total_summary
 FROM dlvmaindb!industrial_department
 WHERE Industrial_department.rep_date >= :start_date
   AND Industrial_department.rep_date <= :end_date
 ORDER BY Industrial_department.rep_date