>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

Martin,
The table structure of both tables have to be identical. In which case you have to add Specs(memo) to table1 and Lot(char) to table2. It should work after that.
HTH,