>I thought they were, turns out one table has a bunch of numerics and the other has a bunch of integers. Don't know how that happend... programmer error. The cRow fields are the same though. DO both STRUCTURES have to be EXACTLY the same, not just the field I want to 'Order' on?
>
>Aloha,
>
>JamesFrom the help file (VFP8 SP1):
"When one of the columns has Memo or General type, unions of differing column types should not be allowed.
In versions earlier than Visual FoxPro 8.0, you needed to perform explicit conversion when performing UNION operations between two fields of different types. Visual FoxPro now supports implicit data type conversion for data types that support it. For more details about implicit data type conversion and data type precedence, rules that UNION clauses follow, and other information, see Data Type Conversion and Precedence in the Remarks section.
UNION clauses follow these rules:
You cannot use UNION to combine subqueries.
Both SELECT commands must have the same number of columns in their query output.
When two columns of different data types are involved in a UNION operation, the data type with the lower precedence is converted to the data type with the higher precedence. For more information, see "Data Type Conversion and Precedence" section in the Remarks section.
Only the final SELECT statement 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."