> Richard,
>
> i got the expected rewsults! now i just have to study
> the query to figure out what it does. -lol-
>
> i tried using AS, but i only did it in one place -
> doh! the error message just moved to the next place i
> didn't do it. i'll know better next time.
>
> thanks for the help.
I am surprised that the query did not work the first time without the optional AS keyword. I
would be interested in knowing why your server requires the AS and mine doesn't.
Regards,
Richard Broersma Jr.