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 :)