Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to represent a Memo fields in an Select - Union command?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement