I can't quite tell what you're trying to do with that SQL. When you say you want to "update all the records that have that employee identifier and are matched and the amounts all equal the amount I am giving it", what does "matched" refer to? You can certainly group by employee ID to match a sum you have, but you don't want all of the records matching that ID, right? I suspect you need a subquery here so that you can group records and also update, but I'm not clear enough on what you want to suggest the SQL.