Combining archived records

1

I have 2 tables a primary table and corresponding archive table

can anyone tell me the ways to combine both table

2

Can you try UNION ALL.

3

ok
thanks