>I am do a sql select statement with a union all, when I ordery by the name of the fields it will not work, when I put the number of the field it will work. Why is this?
>
>Thanks,
>Matt

As for why, I couldn't tell you, but here is an excerpt from the foxpro help file (under select - sql)

UNION clauses follow these rules:

· Only the final SELECT can have an ORDER BY clause, which must refer to output columns by number. If an ORDER BY clause is included, it affects the entire result.

Murray