Hi,
I'm trying to execute the following command using VFP 5.0a:

SELECT field1, ... FROM table 1 UNION SELECT field2,.. FROM table 2 ORDER BY fieldname.

I get an error which states 'Invalid ORDER BY clause.' However, when I reference the column by number, e.g. ORDER BY 3, it orders the result table by the third column. Is there any way to reference the order by clause with a fieldname?

TIA