SELECT Employee.*,lu_locations.Agy_ID,lu_locations.Agy_Name FROM #Request.prefix_db_lookup#.Employee JOIN lu_locations ON lu_locations.Loc_ID = Employee.Loc_ID WHERE Employee.Username = AND Employee.Password = AND Employee.Status = UPDATE #Request.prefix_db_lookup#.Employee SET cfid_token = WHERE Emp_ID = UPDATE #Request.prefix_db_lookup#.Employee SET cfid_token = '' WHERE Emp_ID =