MySQL Forums
Forum List  »  Newbie

Re: MySQL joins
Posted by: Peter Brawley
Date: February 21, 2016 12:01AM

select Client.Lastname, Login.Patient, patient.species
from Login
join client on Login.Clino = Client.Clino
join species on login.Patno = patient.patno
order by client.Lastname, login.patient;

Options: ReplyQuote


Subject
Written By
Posted
February 20, 2016 04:37PM
Re: MySQL joins
February 21, 2016 12:01AM
February 27, 2016 09:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.