Append 2 querys

[digs]

I have 2 queries and would like to put them together without putting them in a table is there a way to do this.

 

[FoFa]

Union or Union All

Select * from table1
UNION {All}
Select * from table2

However they have the same number of columns and each column has to have the same datatype.

Union will remove duplicate rows, Union All returns all rows.