Re: [PHP] Subtotal

2003-03-19 Thread Marek Kilimajer
SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: I'm trying to present a simple SELECT statement GROUPED by date. Ex. WOUNITSOEMCOMMENTSDATE 123 10MeNotes03/18/2003 456 5

RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:19 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Subtotal SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: I'm trying to present a simple SELECT statement GROUPED

RE: [PHP] Subtotal

2003-03-19 Thread Adam Voigt
Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Subtotal SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: I'm trying to present a simple SELECT statement GROUPED by date. Ex. WOUNITSOEMCOMMENTS

RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
Voigt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:37 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Subtotal Umm, add: SUM([rushqty]) AS 'rushsub' To your select, wouldn't that work? On Wed, 2003-03-19 at 11:19, Mike Smith wrote: Here is my query (MSSQL 2000

[PHP] Subtotal

2003-03-18 Thread Mike Smith
I'm trying to present a simple SELECT statement GROUPED by date. Ex. WOUNITSOEMCOMMENTSDATE 123 10MeNotes03/18/2003 456 5 You More Notes 03/18/2003 Total 15 ... I have it working grouping the