followup, that is okay.
Rhino
- Original Message -
From: "Andrew Kuebler" <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>
Sent: Wednesday, October 13, 2004 12:10 PM
Subject: RE: SELECT SUM + 2 JOINS
Here is a snapshot of the order con
followup, that is okay.
Rhino
- Original Message -
From: "Andrew Kuebler" <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>
Sent: Wednesday, October 13, 2004 12:11 PM
Subject: RE: SELECT SUM + 2 JOINS
I forgot, I'm using MySQL 4.1
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
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 13, 2004 11:22 AM
Subject: SELECT SUM + 2 JOINS
> I have a MySQL table with Order#'s (Primary Key).
>
>
>
> I want to total the number of items per order which I do through an inner
> join to the order co
I have a MySQL table with Order#'s (Primary Key).
I want to total the number of items per order which I do through an inner
join to the order contents, but then I want to also get a total on the
amounts a customer has been billed to make sure there isn't a customer that
has been shipped somethi
