- Original Message -
From: "Claire Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 11:28 AM
Subject: distinct based on two fields--please help
> I have a table like this
>
> name price type
> A10 1
From: Claire Lee [mailto:[EMAIL PROTECTED]
> I have a table like this
>
> name price type
> A10 1
> B30 2
> A20 1
> B20 2
>
> would like to distinct based on name and type, do a
> sum and get the following result
>
> name price type
> A
I have a table like this
name price type
A10 1
B30 2
A20 1
B20 2
would like to distinct based on name and type, do a
sum and get the following result
name price type
A 30 1
B 50 2
How do I do this with one sql qu
And I have a table like this
click send on accident?
A
Don't leave me hangin'!!
-- Tripp
--- Claire Lee <[EMAIL PROTECTED]> wrote:
> I have a table like this
>
> name price type
> A
>
>
>
> __
> Do you Yahoo!?
> New and Improved Yahoo
I have a table like this
name price type
A
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
