Multiple SQL tables added together without a JOIN

Question

I have two tables:

  FirstField | SecondField | ThirdField

  FirstValue   SecondValue   ThirdValues

----------------------------------------------
 FirstField  | SecondField | ThirdField

 OtherValue1   OtherValue2   OtherValue3

What I need it to add those two tables together into one SQL query. They can not be joined as I don't have anything to join them on and that's not what I want. I want my new table to look like:

 FirstField | SecondField | ThirdField

 FirstValue   SecondValue   ThirdValues

 OtherValue1   OtherValue2   OtherValue3

This may be very simple but I am new to SQL and have been unable to find any help elsewhere.

Answer 1

Try UNION ALL:

SELECT FirstField ,SecondField ,ThirdField 
FROM   Table1
UNION  ALL
SELECT FirstField ,SecondField ,ThirdField 
FROM   Table2

If you want to remove duplicate rows use UNION instead.

SELECT FirstField ,SecondField ,ThirdField 
  FROM Table1
 UNION
SELECT FirstField ,SecondField ,ThirdField 
  FROM Table2