[thelist] Query Logic

[Casey Crookston]

Spot on Joshua.  Thank you.

----- Original Message ----- 
From: "Joshua Olson"


>> -----Original Message-----
>> From: Casey Crookston
>> Sent: Tuesday, February 19, 2008 11:30 PM
>>
>> What I need, however, is only the first row per each new
>> store.  Or....
>>
>> ID     Store        Description
>> 1       StoreA     description1
>> 4       StoreB     description4
>
> Casey,
>
> This is a common question (that I for some reason always feel obligated to
> answer!).  It looks like you are using "the lowest id" to designate the
> "first" record within a group.  See these posts for more information:
>
> http://lists.evolt.org/archive/Week-of-Mon-20020318/107145.html
> http://lists.evolt.org/archive/Week-of-Mon-20040223/156066.html
>
> Basic takeaway from those posts:
>
> Find the id corresponding to the minimum record within each group then 
> join
> back to the table to get the details:
>
> SELECT *
> FROM myTable
> INNER JOIN
> (
>  SELECT Min(id) AS id
>  FROM myTable
>  GROUP BY Store
> ) drvtable
> ON drvtable.id = myTable.id
>
> Joshua