Your query is not an equivalent to the original one, as the result of subquery is just list of 'gl_group_id' and then you are updating records with these gl_group_id, not records filter by transacted_on and belongs_to_hcare.
Cheers, Max
Check-out free open-source utility Sql Server Replication Explorer[/url]