SQL：在所有EXCEPT指定列中防止重复

I have something of an odd question: I have two tables I wish to join with a Union. I don't want any duplicate columns, however each table has an extra variable I wrote into the SELECT clause specifying where they came from:I have something of an odd question: I have two