SELECT * FROM #Request.prefix_db_lookup#.lu_locations WHERE Loc_ID = AND Agy_ID = SELECT * FROM #Request.prefix_db_lookup#.lu_locations WHERE Agy_Mailing = AND Loc_ID != SELECT * FROM #Request.prefix_db_lookup#.lu_locations WHERE Agy_Phone = AND Loc_ID !=