select raza.id, raza.deno
from animales,raza
where animales.raza=raza.id 

select animales.id, raza.deno
from animales,raza
where animales.raza=raza.id
order by raza.deno