NUMMERNKREIS SÄTZE EINFÜGEN

select CLIENT, OBJECT, SUBOBJECT, NRRANGENR, 2024 as TOYEAR,

FROMNUMBER, TONUMBER, 00000000000000000000 as NRLEVEL, EXTERNIND 

from NRIV as a 

where TOYEAR = 2023 

and not exists (

SELECT CLIENT from NRIV as b 

where a.CLIENT = b.CLIENT and a.OBJECT = b.OBJECT and b.TOYEAR = 2024 )