Symptom:
Select error: Incorrect syntax near the keyword ‘UNION’ is received when running saved report with multiple groups created from Custom Constituent Export File.

Cause:
Report was saved with a Merge Field definition, that has since been deleted from system.
Resolution:
Navigate to Options tab of report and select and save a new set of Merge fields.
Additional Information: