SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA

Duplicate Problems

SET innodb_strict_mode = 0; SELECT Problem_ID ,Description, COUNT(*) as tot_count, pAssessments.Assmt_ID,pAssessments.Patient_ID,pPatients.Pt_Last,pPatients.Pt_First FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProblem.Assmt_ID AND pAssessments.Status=0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pPatients.Status < 2 WHERE pProblem.Status = 0 GROUP BY pProblem.Problem_ID HAVING COUNT(*) > 1

Problem_ID	Assmt_ID	Patient_ID	Description	Patient Name	Total_counts	Agency database
#Problem_ID#	#Assmt_ID#	#Patient_ID#	#Description#	#Pt_Last#, #Pt_First#	#tot_count#	#Request.prefix_db_agency#