The other possibility is to do a WHERE NOT IN type of query, but UNION seems a better overall solution, unless query speed is a factor and the two separate queries somehow perform better than the ...

Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.