Chris W. Parker wrote: > > To make a long story short, what's the best way to display/return only > the first occurence of prod001? > ... GROUP BY id