SELECT Member.*, MemberMedicalCondition.MedicalConditionTypeId, MedicalConditionType.MedicalConditionCode, MedicalConditionType.MedicalConditionDescription FROM `Member` JOIN MemberMedicalCondition on MemberMedicalCondition.MemberId = Member.MemberId JOIN MedicalConditionType on MedicalConditionType.MedicalConditionTypeId= MemberMedicalCondition.MedicalConditionTypeId