Union Query to Combine Results from 2 Queries

[KWSMan]

Good Afternoon All,



I am very new to Access and have been tasked with doing a compare. I need to join the results of two queries. Below is the SQL Union query that I have been able to come up with so far. Unfortunately, when I try to run the query I receive an "Invalid SQL Statement; expected 'Delete', Insert', 'Procedure', 'Select', or 'Update'.

SELECT FORM_number, ED_DATE, COMPANY, ST, Source 
FROM [TblProductWC Without Matching Copy Of Workers Compensation Forms]
UNION [ALL]
SELECT Form_Number, Edition_Date, Companies, State, Source
FROM [Copy Of Workers Compensation Forms Manual Without Matching TblPr];

Please help.

Thank you in advance!!!

[pbaldy]

For starters, it would be:


UNION ALL

ie no brackets.