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