Thanks, I tried the latter, but it didn't work. I'll try you're suggestion.
curtis
- Original Message -
From: "Quentin Bennett" [EMAIL PROTECTED]
To: "'Curtis Maurand'" [EMAIL PROTECTED]; "MySQL List"
[EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:44 P
Hi,
Yes, in MySQL you can go
select handle, sum(total) as t group by handle order by t;
in ANSI (?) you can go
select handle, sum(total) group by handle order by 2;
2 being the column number of the result.
Regards
Quentin
-Original Message-
From: Curtis Maurand [mailto:[EMAIL
On Mon, 19 Mar 2001, Curtis Maurand wrote:
Hi,
Just a quick quesiton, I have a table that contains difined as
create table picks(
handle char(30) primary key,
...
total int unsigned);
there is a user table that has a list of handles and other user info. handle is the