SELECT Gh_hall.x_axis, sum(Gh_data.data), Gh_fields.id;
 FROM  gamehalldlv!gh_tables INNER JOIN gamehalldlv!gh_fields;
    INNER JOIN gamehalldlv!gh_data;
    INNER JOIN gamehalldlv!gh_date;
    INNER JOIN gamehalldlv!gh_hall ;
   ON  Gh_hall.id = Gh_date.hall_id ;
   ON  Gh_date.id = Gh_data.main_id ;
   ON  Gh_fields.id = Gh_data.field_id ;
   ON  Gh_tables.id = Gh_fields.table_id;
Where gh_fields.table_id= 2  AND gh_data.mode_id= 1 ;
    AND gh_date.rep_date >= CTOD(dt) ;
    AND gh_date.rep_date <= CTOD(dt2); 
 GROUP BY Gh_data.field_id, gh_hall.id;
 ORDER BY Gh_data.field_id
	INTO ARRAY incomes_arr1