RE: SQL basic questions

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

If you post the statement so we can see what you are trying to
accomplish I'm sure someone can help.  Without it I'm not sure anyone
can do much.

Rick

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> steema@xxxxxxxxxxxxx
> Sent: Monday, April 24, 2006 8:20 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL basic questions
>
> HI I want to be able to use the Select Distinct feature on a
> key level.
> I have a file w/ Acct and model #, and I want to list only
> one model per acct. instead when i do Select Distinct
> currently, I get many per Acct/model. Is there a way to make
> this break on the key?

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.