MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: One-to-many query
Posted by: Wladimir Coka
Date: August 23, 2009 01:18PM

Something like this should work

SELECT * FROM Pet
JOIN Disease on Disease.PetID=Pet.PetId
JOIN Exams on Exams.PetID=Pet.PetId
Where Disease.descripcionCol="epilepsy" and (Exams.descriptionCol="wheat allergy" or Exams.descriptionCol="penicillin allergy")

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
One-to-many query
3496
Joni Lindqvist
August 17, 2009 11:52AM
Re: One-to-many query
1790
Wladimir Coka
August 23, 2009 01:18PM


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.