SELECT pPatients.Patient_ID,pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pAssessments.F26,pAssessments.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pPatients.Status < 2 AND (LEFT(pAssessments.F26,1) = '1' OR LEFT(pAssessments.F26,1) = '4') AND pAssessments.Status = 0 GROUP BY pAssessments.Assmt_ID SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE pWoundsVitals.VitalOrWound = 'wound' AND Assmt_ID IN ('#ValueList(GetList.Assmt_ID)#') AND Status = 0

Patients With Wounds

Patient	Assessments
#PatientLast# #PatientFirst#	SELECT * FROM GetWndList WHERE Assmt_ID = '#Assmt_ID#' #F26# #WoundType#