Código sql:
Ver originalSELECT * FROM adm_cargo, adm_departamento, adm_directorio
WHERE dire_cargo = carg_codigo AND dire_departamento = depa_codigo
AND YEAR(CURDATE())>=dire_inicio_eleccion AND YEAR(CURDATE())<dire_fin_eleccion
ORDER BY carg_tag
así?
No das muchos detalles.