Hi Sergey,

It works perfectly.

Thanks,

TFISHER

>Try UNION ALL

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

>>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