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