SELECT * FROM #Request.prefix_db_agency#.pAssessments LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID WHERE pPatients.Loc_ID = AND pAssessments.Patient_ID = AND pAssessments.Assmt_ID = AND pAssessments.status = 0 AND pPatients.status = 0