Ver originalSELECT T2.ID, `name`, `estado` *FROM `tabla_2` T2 INNER JOIN tabla_1 T1 ON T2.id = T1.idWHERE `estado` = 1ORDER BY `name` ASC