>>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

Dear Phil,
Dont put paranthesis () around each UNION SELECT. This might be the reason

Abdul Ahad