[thelist] SQL record filtering

[dn at dittodesign.co.uk]

Thanks Joshua I'll give it a go. Looks easy 8-)


Thanks for the help, I'll let you both know how
I get on.

regards,

Darren Yates
dn at dittodesign.co.uk
http://dittodesign.co.uk


----- Original Message -----
From: "Joshua Olson" <joshua at waetech.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, September 11, 2002 5:39 PM
Subject: Re: [thelist] SQL record filtering


> ----- 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
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !