>I think Erik hit the nail on the head with DELETED() when more than one table involved.
>Another note: I used to have problems when my local alias's were single letter and matched the old A-J alias names for the first 10 areas. I don't know if this is still a problem or not, but I just got to the point where I didn't (couldn't) trust it, and used SQL local alias of 2 or more letters.
Well, it turned out to be the DELETED(). Still not sure why I had that in there. This was the first SELECT statement I ever did, so maybe I didn't know the SELECT would follow the DELETED status.
I never had a problem with one letter aliases. Maybe it's not a problem anymore?
Thanks to both of you,
-Michelle
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