>UNION will not work with memo, picture or blobs.
I don't see it in Help. It says
The UNION clause combines the results from two or more SQL SELECT statements into a single result set containing rows from all the queries in the UNION operation.
Note
When one of the columns is of Memo, General, or Blob type, performing unions of differing column types is not allowed.
---------------------------------------------------------------------------
Use UNION ALL instead of UNION.
If it's not broken, fix it until it is.
My Blog