Since the number of columns are high,I cannot use the joins in the script to declare each and every column at all times.

Please let me know is there any other possibilities for different data structures to compare with huge amount of columns.

I am not suggested to use third party tools. So plz provide me in the form of SQL script if possible.