>>Hi,
>>
>>I am trying, and failing, to include a memo field in a UNIONed SQL SELECT. I've pared the statement down to the following:
>>
>>

>>SELECT app_activitycomments ;
>>	FROM appointments ;
>>	INTO CURSOR c_Temp ;
>>	WHERE !app_activity AND app_clientfk > 0 AND app_GroupnameFK=0 ;
>>	UNION ;
>>		SELECT app_activitycomments ;
>>			FROM appointments;
>>			WHERE !app_activity AND app_clientfk=0 ;
>>			UNION ;
>>				SELECT app_activitycomments ;
>>					FROM appointments ;
>>					WHERE app_activity
>>

>>
>>and i get the error:
>>
>>"Operation is invalid for a Memo, Blob, General or Picture field"
>>
>>I can't have a memo in a UNION SQL SELECT statement?
>>
>>TIA, j
>
>Jill,
>
>With the UNION ALL you may end up with duplicate records
>
>The statement above can be rewritten without a UNION
>
>

>SELECT app_activitycomments ;
>    FROM appointments ;
>    INTO CURSOR c_Temp ;
>    WHERE  ( app_activity ) ;
>        or ( app_clientfk > 0 AND app_GroupnameFK=0 ) ;
>        or ( app_clientfk=0 )
>
>&& if app_clientfk cannot be negative
>
>SELECT app_activitycomments ;
>    FROM appointments ;
>    INTO CURSOR c_Temp ;
>    WHERE  ( app_activity ) ;
>        or ( app_clientfk = 0 ) ;
>        or ( app_GroupnameFK=0 )
>
>

Hi Gregory,

Thanks for your input...but, the SELECT i posted here was a stripped down version (to illustrate my specific problem)...there are many other fields and tables involved in the real statement.

I ended up doing the UNION ALL, then applied a UNIQUE index to get the unique records I needed.

Thanks, j