Re: To get records without repeation of two fields.

Hi,
Follow-up of my last query....

I need to get values from a table where the two fields cannot have repeated values.Let the table be prod_master which has a primary key product_code.There are other two fields product_type and label_code. The requirement is that select query should fetch values which doesnt have product_type and label_code values repeating.

example :
i want to get those records which have values product_type and label_code (together)distinct or are unique value. if the table have values :
product_type label_code

123            334
456            123
123            334
123            123

I want to get the only the values :
product_type label_code

123            334
456            123
123            123

Hope this makes it more clear.

Anitha Shenoy

Anitha Shenoy.

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E3A23F9.56BAC826_at_exesolutions.com>...
> Anitha S wrote:
>
> > Hi,
> > I need to get values from a table where the two fields cannot have
> > repeated values.
> > Let the table be prod_master which has a primary key
> > product_code.There are other two fields product_type and label_code.
> > The requirement is that select query should fetch values which doesnt
> > have product_type and label_code values repeating.
> > so how would be the select query...?
> > Pls help!
> >
> > Regards,
> > Anitha Shenoy
>
> You need to clarify your request with a bit of sample data showing what
> it looks like in the table and what you wish to retrieve.
>
> But taking a wild stab at your question ... I would say that you can not
> do it except by means of GROUP BY or SELECT DISTINCT.
>
> Daniel Morgan
Received on Fri Jan 31 2003 - 08:07:45 CST