Single fixed query can only select the same fixed number of columns.
As you select all columns from both ends, so you will get all values.
Nulls can be values by different ways. Most robust and neat one would be:
I'm only compare 3 -4 values per table, which is now part of my query and I'll only get those values back now and now I'll be writing those to a file,
I'll look at what you provided for NULL values and test it. how can i create my log file though from SQL or even get an code of [true] so i can create the log file? I only want the log file created if the column don't match