Comments by Aman singh Parihar (Top 1 by date)

This worked for me, as I have no relation between the two of the tables, number of columns and the type are not even same and I want the data in one result set.

SELECT table1.Column1, table2.Column2 FROM table1
INNER JOIN table2 ON 1 = 1