>That's the same version I'm running. I wonder if it was different in VFP6, I don't have it to test.

It does not work in VFP6 SP5 either. I can't test any earlier than that. Looking at the help for error 1851 (Selects are not UNION compatible), it says "Data types or sizes of fields being projected in each SELECT statement are not identical" (emphasis mine).