Mike Morton said: > Hey y'all - I have been at this too long today - this is driving me > nuts! > > Table: > Date (y-m-d),amount (decimal),dealercode > > I am looking for a query that will give me the sum of each of the > distinct dealercodes for a specific date range. > > Something to the effect of: > Select (distinct dealercode),sum(amount) as total where date between > 'this' and 'that' > > The trouble that I am running into is that I cannot seem to get that > done in one query - splitting it up into 2 is easy enough - do the > distinct dealercode, then loop through those to do the sum between date > query - but ideally I would like to do it in one query. If this is > possible to do - how? > > TIA! > > > > -- > Cheers > > Mike Morton > > **************************************************** > * > * Tel: 905-465-1263 > * Email: [EMAIL PROTECTED] > * > **************************************************** > > "Indeed, it would not be an exaggeration to describe the history of the > computer industry for the past decade as a massive effort to keep up > with Apple." > - Byte Magazine > > Given infinite time, 100 monkeys could type out the complete works of > Shakespeare. Win 98 source code? Eight monkeys, five minutes. > -- NullGrey Welcome to 'Group By' Table: Date (y-m-d),amount (decimal),dealercode select sum(amount),dealercode from table where date > 'date1' and date < 'date2' group by dealercode
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]