Is this possible? Using SQL Server 2005.......

SELECT *
FROM Data0304 
UNION 
SELECT *
FROM Data0506
UNION 
SELECT *
FROM Data0708
Edit
Report