SELECT c.*, a.tat_rge_ruc_usr, a.*
    FROM usr_sat_ecf.tab_aiecf_equip_lacre c, usr_sat_ecf.tab_aiecf a
    WHERE  c.tai_num_aiecf = a.tat_num_aiecf
             AND a.tat_edo_aiecf = 1
             AND tat_rge_ruc_interv  = '253528445'
             ORDER BY c.tal_cod_lacre;