[thelist] SQL record filtering

[Joshua Olson]

----- Original Message -----
From: <dn at dittodesign.co.uk>
Sent: Wednesday, September 11, 2002 11:00 AM


> There is only one table used in the database hopefully making
> it very simple.
>
> It hasn't been normalised in any way. The relevant Fields
> include
>
> phone model, phone make, Master category, category
> and ID

Based on a flat table structure in Access, something like this should work:

SELECT *
FROM theBigTable
WHERE ProductID IN
(
  SELECT Min(ProductID)
  FROM theBigTable
  WHERE MasterCategory = *yourFinalMasterCategory*
  GROUP BY CategoryID
)

The field names may be off, but the basic concept should work.

HTH,

-joshua