I write really long SQL statements like this:
SELECT tblDisease.RespRate_Mod FROM tblPTtoDX JOIN tblDisease ON tblPTtoDX.DiseaseID = tblDisease.DiseaseID JOIN tblAllPatients ON tblPTtoDX.PatientID = tblAllPatients.PatientID WHERE tblPTtoDX.PatientID= + patientID