God is real - unless declared integer.
I'm a German database programmer with more than 25 years of experience with commercial and administrative Information Systems..
No error - Yet....
Of course it does not work -
but look how fast it is!! - HTB
Always try to do things in chronological order; it's less confusing that way.
MERGE INTO Pat_All AS A
USING Pat_New AS N
ON (A.PATNUM=N.PATNUM)
WHEN MATCHED THEN UPDATE SET
A.PATSEX=N.PATSEX
WHERE A.PATSEX IS NULL AND N.PATSEX IS NOT NULL;
Reserved for future mistakes by our developers.