Hello,

I have two tables that I would like to combine. I have tried to use a UNION clause, (a short version of the code is below) however, I get an error that says:

"Operation is invalid for a Memo, General or Picture field."

I do have memo fields in the tables.

If I can not use a UNION clause to combine these two tables into one view how do I do it?


SELECT Elements.melementlan;
FROM am_utility!elements;
UNION ;
SELECT Elements_Ordinances.melementlan;
FROM am_utility!elements_Ordinances


Thanks

TFISHER