>I had this just yesterday. The same union works in SQL. I found that it's the field size that was killing my union - once I made both queries with the same size results it worked.
Yep. That's what I ended up doing as well.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!