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.