>>Philip,
>>
>>Type is a VFP keyword (also a FPW keyword, but maybe it isn't as strict). That could be the issue. Try renaming it and see if that helps.
>>
>
>Hi Josh,
>
>Thanks for the input. Unfortunately, changing the TYPE word in the SQL statement to another made no difference.
>
>Phil

I have never seen UNION clauses with ( ) around them. Try removing those.