I am new to SQL and I am not sure what to Google. I have three tables with different numbers of columns. I would like to combine these following three tables into a single column(no duplicates).
Col1 Col2 Col3 1 a aa 2 b ab 3 c bb
Col1 Col2 123 Test 456 Test2 346 Test3
Col1 Col2 Col3 Col4 5695 93234 ABC CDE 4534 92349 MSF KSK 3244 12323 SLE SNE
FileOutput 1aaa 123Test 569593234ABCCDE 2bab 456Test2 453492349MSFKSK ...
Any help would be much appreciated. Thanks!