>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