How to recover data from two tables whose column names are the same

advertisements

How to retrieve data from two tables whose column names are the same?


If you want to include rows from both tables, you can use UNION ALL:

SELECT Col1, Col2, Col3 FROM Table1
UNION ALL
SELECT Col1, Col2, Col3 FROM Table2