MySQL joins

[Jim Sawyer]

I have a join with two tables as follows:

select Client.Lastname, Login.Patient
from Login
inner join Client
on Login.Clino = Client.Clino
order by Client.Lastname, Login.Patient;

I would like to join a third table so I can include

Patient.Species

where

Login.Patno = Patient.Patno

I cannot figure out how to incorporate this third table in
the mix. Can someone help with this?

Thanks,
Jim Sawyer