Re: distinct based on two fields--please help

2004-08-03 Thread Rhino
- 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 > B30 2 > A20

RE: distinct based on two fields--please help

2004-08-03 Thread Mike Johnson
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