😀 This forum has proven a handy resource so I'll be sticking around, especially now I have a post count above 1 😎

Thanks dwain, found the problem (which I would have found a lot quicker if I took note of your first reply in relation to primary keys). There were 2 records...

I see what you mean and it makes sense but there were 39 records that got updated out of the possible 40. It looks to be failing on 'c2.ClientName IS...

Thanks dwain, that looked to work... somewhat. I just ran some checks and it missed one, or rather it seemed to 'ZZ' its entry in the c2 referenced table and...

Yes thats correct some of the clients have been terminated correctly with the 'ZZ ' appended, so I want to azoid 'ZZ ZZ 'ing them.

And the 'ClientName' field isn't the...