SQLTeam.com | Weblogs | Forums

Combining archived records

I have 2 tables a primary table and corresponding archive table

can anyone tell me the ways to combine both table

Can you try UNION ALL.

ok
thanks