Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Hi Naomi,
Finally figured it out. If the select statement has a memo field in it, you can not use the distinct keyword. But the results are still fairly distinct.
Thanks for you help.
Beth
>Ok, try both selects without the first part before UNION. I think for these two select statements they are not needed. Also you may want to try to simplify these selects (or start building them from simplest to complex) until you find the offending piece. Right now it's still hard for me to figure out what the problem may be.
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