[thelist] SQL record filtering
Joshua Olson
joshua at waetech.com
Wed Sep 11 11:41:01 CDT 2002
----- 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
More information about the thelist
mailing list