Re: To get records without repeation of two fields.

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 - 01:21:29 CST