inside your subquery, it looks like you are limitting the "LKC.seq" to 1 in order for LockCombination to be joined in (and thus LKC.seq to have a value in your subquery), but in your merge criteria, you're determining a match must have "LKC.seq" = 2. So I'm guessing that you simply never get a match to do an update with.