<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
select a.id_localidad,
a.no_descripcion,
a.no_cod_area
from loc_localidades as a, loc_provincias as b
where a.id_provincia = b.id_provincia
and b.no_descripcion=''
order by a.no_descripcion