Can anyone share the UNION syntax? I can't append two queries I wrote.

select column1, column2
from table1
union
select column1, column2
from table2

You can also use

UNION ALL

.

UNION

removes duplicates,

UNION ALL

does not. Note that the columns in the unions must be the same data types.