No offence joe, my reason for asking was due to slivers of memories about there being a possible performance hit with the update table being in the Join rather than the from and just wanted to clarify if this was still the case.

In regards to the != Its an old colding habit from a previous life of being a c/c++ programmer. :Whistling:

I do know about the merge, and it has its place, but there are occasions when it doesnt do as well as an update, horses for courses.

In regards to your other comments, meh, people are entitled to an opinion, if its worth considering I'll consider it, if not it gets thrown away with all the other junk.