SELECT * FROM #Request.prefix_db_agency#.employee WHERE Loc_ID = AND Status = SELECT * FROM #Request.prefix_db_agency#.employee WHERE Loc_ID = AND Emp_ID = SELECT * FROM #Request.prefix_db_agency#.employee WHERE Emp_Email = AND Emp_ID != SELECT * FROM #Request.prefix_db_agency#.employee WHERE Emp_Telephone = AND Emp_ID != SELECT * FROM #Request.prefix_db_agency#.employee WHERE Username = AND Emp_ID != SELECT count(Emp_Email) as email from #Request.prefix_db_lookup#.pEmployee WHERE Emp_Email = AND Loc_ID = #session.agencyid# group by Emp_Email having count(Emp_Email) >= 1 SELECT count(Username) as username from #Request.prefix_db_lookup#.pEmployee WHERE Username = group by Username having count(Username) >= 1 SELECT count(Emp_Telephone) as phone from #Request.prefix_db_lookup#.pEmployee WHERE Emp_Telephone = group by Emp_Telephone having count(Emp_Telephone) >= 1 SELECT * FROM #Request.prefix_db_agency#.physicians WHERE Loc_ID = SELECT * FROM #Request.prefix_db_agency#.physicians WHERE Loc_ID = AND Phys_ID = SELECT * FROM #Request.prefix_db_agency#.physicians WHERE Phys_Email = AND Phys_ID != AND Phys_Email != '' SELECT * FROM #Request.prefix_db_agency#.physicians WHERE Phys_Phone = AND Phys_ID != SELECT * FROM #Request.prefix_db_agency#.physicians WHERE Username = AND Phys_ID != SELECT * FROM #Request.prefix_db_agency#.payers WHERE Loc_ID = SELECT * FROM #Request.prefix_db_agency#.payers WHERE Loc_ID = AND Pay_ID =