Looking for help on whether the following query can be simplified. You want the EXCEPT clause. Check out the microsoft documentation on EXCEPT. Google "T-SQL EXCEPT" and that should get you going.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results