:exclamation: This query will work fine is GLPOST is not empty. But if it is empty, the condition will become :

WHERE ACCTID NOT IN (null)

which will never be true neither false !). So no line will be updated, instead of all lines :hehe:

Always be careful with NOT IN. Prefer Lynn Pettis solution : IN