July 21, 2008 at 6:57 pm
Jeffrey Williams (7/21/2008)
The alias t1 was used in the sub-query and I didn't remove it. Modify the sum statements and change the reference from t1 to t and that should do it.
**Ding**Ding**Ding...we have a winner!
Man, thank you so much for your patience and help Jeffrey...the data looks great. Sorry for not being so clear from the beginning.
July 21, 2008 at 8:36 pm
jonathanmreynolds (7/21/2008)
Jeffrey Williams (7/21/2008)
The alias t1 was used in the sub-query and I didn't remove it. Modify the sum statements and change the reference from t1 to t and that should do it.**Ding**Ding**Ding...we have a winner!
Man, thank you so much for your patience and help Jeffrey...the data looks great. Sorry for not being so clear from the beginning.
I am glad we were finally able to get this working for you.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply