SQL Query to retrieve results from two equally designed tables

Question

How can I query the results of two equally designed tables?

if table1 contains 1 column with data:

abc

def

hjj

and table2 contains 1 column with data:

uyy

iuu

pol

then i want my query to return

abc

def

hjj

uyy

iuu

pol

but I want to make sure that if I try to do the same task with multiple columns that the associations remain.

Answer 1

SELECT col FROM t1 UNION SELECT col FROM t2

Union reference.

Answer 2

SELECT 

    Column1, Column2, Column3 FROM Table1

UNION

SELECT 

    Column1, Column2, Column5 AS Column3 FROM Table2

ORDER BY 

    Column1

Notice how I do an order by at the end and that Column5 in Table2 is the equivalent of Column3 in Table1. The Order By is of course optional, but allows you to control the order of items from both tables once they are combined.

Answer 3

Use a UNION

SELECT *
FROM TABLE_A
UNION
SELECT *
FROM TABLE_B

UNION will give you all distinct results, as where UNION ALL will give you results combined from the sets.

Answer 4

sev, since union is the solution to what you described and you say that didn't work, perhaps you can provide the code you wrote that didn't work as clearly we are missing part of the picture. Are you positive the second table has the records you want? How do you know for sure?