>>I just found something weird that I am looking to get some additional information on. It is in regards to a UNION clause where, being executed from the command prompt works, but, when being executed from the code, if the cursor of the UNION table is at EOF(), does not grab the related record.
>>
>OTHERWISE is a reserved word.
>What if you swap the order of the UNIONed queries?
Other was used here as an example. The name of the actual table cannot conflict with VFP.