SELECT * FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.patient_ID WHERE pAssessments.Assmt_ID = AND pAssessments.status = AND pPatients.status =