Textpattern CMS

#16 2008-07-02 23:11:12

Sam

Member

From: New York City

Registered: 2004-06-26

Posts: 127

Website

Re: Need help with complex MySQL query... any takers?

Thanks again. The final statement looks like so:

select * from updates a, (select max(id) as id, name from updates group by name) b where a.id = b.id

Last edited by Sam (2008-07-02 23:12:06)

---

Sam Brown
sambrown.me | welovetxp.com