>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

Not with a UNION select. You must use the column id # to reference it.