SELECT SUM(gh_data.data), foo.fld_id, foo.rep_date
FROM (SELECT gh_fields.id AS fld_id, gh_date.id AS date_id, gh_fields.table_id, gh_date.rep_date , Month(foo.rep_date) as M
FROM gh_fields, gh_date
         WHERE gh_fields.table_id= 2   AND gh_fields.sel=.T.
    AND gh_date.rep_date>=:start_date AND gh_date.rep_date<=:end_date 
             AND gh_date.hall_id IN (SELECT id FROM gh_hall WHERE sel=.T.)
) AS foo
            LEFT JOIN gh_data 
                        ON (foo.fld_id = gh_data.field_id AND foo.date_id =gh_data.main_id)
WHERE (gh_data.mode_id= 1  OR gh_data.mode_id IS NULL) 
GROUP BY foo.fld_id, foo.M
ORDER BY foo.fld_id