Kelly, > always a great place to get help!! > > here's what i have data wise: > > Tag ID Date > > ABC 11 2012 > DEF 11 2011 > GHJ 11 2010 > HHH 22 2012 > ZZZ 22 2011 > AAA 22 2010 > AAK 33 2012 > AAD 44 2012 > YYY 44 2010
> > My desire is to still keep the "groups" of ID together > > i'd LIKE > > AAA 22 > HHH 22 > ZZZ 22 > AAD 44 > YYY 44 > AAK 33 > ABC 11 > DEF 11 > GHJ 11 > > but > select * order by tag, date group by ID doesn't work First, your expected output and your SELECT don't align. Where is the Date column? Second, stop using SELECT * very bad habit. Ok, for debugging/testing, bad for production. > NOTE i do NOT want to sort by ID. I just want the list sorted by Tag, > subsorted by date. BUT I want all the IDs together because the Tag might > change from date to date for ID Your post/requirements are contradictory: - "My desire is to still keep the "groups" of ID together" - "NOTE i do NOT want to sort by ID" If you want them "together", they need to be sorted - "I just want the list sorted by Tag, subsorted by date." Which is it, do you want the ID together or the Tags by date? Sean