ednesday, October 13, 2004 11:58 AM
To: Andrew Kuebler
Cc: [EMAIL PROTECTED]
Subject: RE: SELECT SUM + 2 JOINS
OK, that makes better sense.
Please respond to the list (you should always try keep any list responses
CC:ed to the list so that everyone else can help and learn from the
exchange, t
> Sent: Wednesday, October 13, 2004 11:37 AM
> To: Andrew Kuebler
> Cc: [EMAIL PROTECTED]
> Subject: Re: SELECT SUM + 2 JOINS
>
>
> I believe what you want needs two queries, one to total up on the
> order# the other to total up by customer. I wouldn't recommend
>
I believe what you want needs two queries, one to total up on the order#
the other to total up by customer. I wouldn't recommend trying to do it
all at once as they are two different (but similarly asked) questions.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Andrew Ku
It's awfully hard for anyone to help without seeing the SQL that you are
trying to execute. Ideally, the full descriptions of the tables involved and
a few rows of sample data would make it a lot easier for us to be able to
visualize what you are doing but you sometimes get a useful answer from the