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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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