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'.
Code:
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!!!