Raven B.:
Попробуй так:
Код:
sql_q = "SELECT control_t.control_id, FIRST(ph_f_control_comp_t.control_comp_id), FIRST(control_t.control)"
sql_q = sql_q & " FROM ph_f_control_comp_t, control_comp_t, control_t"
sql_q = sql_q & " WHERE ((Str(control_comp_t.control_id) = Str(control_t.control_id))"
sql_q = sql_q & " AND (str(ph_f_control_comp_t.control_comp_id)=str(control_comp_t.control_c omp_id))"
sql_q = sql_q & " AND (ph_f_control_comp_t.norm_id = '" & veg & "')) GROUP BY control_t.control_id;"