You can do this way.

CREATE CURSOR crsTemp (specs M)
Select Lot, style, specs ;
  from lot, crsTemp ;
  where .... ;
Union
Select SPACE(LEN(lot.lot)) as Lot, style, specs ;
  from Specs ;
  where ...

Make sure that the size of the fields in two selects match otherwise you'll get the same error.

>How can I represent memo fields in Select - Union statement?.
>I have 2 tables with s common field but one of these table has a memo field and I would like to include it in my dataset.
>
>Table 1: Lot (char), Style (Char)
>Table 2 Style (char),Specs(memo)
>I tried with a similar next sql command but I got trhe next error:
>"SELECTs are not UNION compatible"
>
>Select Lot,style," " as specs from lot where .... ;
>Union
>(Select " " as Lot,style,specs from Specs where ...)
>
>Thanks in advance
>Martin