Terry,

If you have different set of id,price1,price2,price3,price4,price5,cost associated with one pid,lot combination than wich one you want to see in the result?

>How do I get a subset of my table where only 2 of the seven fields that I need in the result can be and must be distinct?
>
>select distinct pid,lot from products
>(gives the right # of records)
>
>select distinct pid,lot,id,price1,price2,price3,price4,price5,cost
>(gives too much distinction even though I need the other fields)
>
>Thanks :)