Need help on a join query sqlite iphone
===

I have two tables Visits and Labs 

Visit has these fields: id,patientID
 
Labs has these fields: id, VisitID 

And Visit.id = Labs.VisitID
 


I want to get all old lab reports of a patient.... but in lab table i dont have patientID field,
so for that i need to make use of visitID field, using which i can connect to Visit table and there i have patientID

so now using visitID(a common field) i want to find out all old lab reports of a patient

now i want to get all labs of a patient ( i know patientID) 

Can anyone suggest me join query for this?