select
animals.id,animals.name, species.commonname
Where
animals.species=species.id






select
animals.id,animals.name, species.commonname, transmitters.freq
Where
animals.species=species.id and 
deployments.animal = animals.id and
deployments.transmitter = transmitters.id