Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>The memo field is not allowed in the group by but is also not allowed in the result set. (this one bit me recently as well ) It would be meaningless in any case, unless it is the same for every record.
>>
>>Thanks for helping me with this clarification. Because the memo fields were from the 'child' linked table, they were the same. This will be one for the memory bank.
>
>You might try MAX(memofield). Ran into that recently but can't remember if it worked or not.
MAX() of a character column where all the values are known to be the same just seems "incoherent", doesn't it? ;)
Précédent
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