>>Yes. And actually I just tested that syntax and it worked fine. So, that works.
>
>Great, thanks
It doesn't mean I recommend to keep your current UPDATE command as is. I'd rather re-format it to MERGE and to simplify its meaning.
If it's not broken, fix it until it is.
My Blog