Re: SQL Question, Aggregate and nonAggregate fields.

I could find no difference between select max(a.publish_date), a.series_id, (select b.article_id from dtv_articles b where a.publish_date=b.publish_date and a.series_id=b.series_id) from dtv_articles a group by 2,3; and select max(publish_date), series_id, article_id from dtv_articles group by 2,3; I do want to find the article_id for the max publish_date for each group of series_id values. Not just the max(publish_date) itself. As in... select max(publish_date), series_id from dtv_articles group by 2; -- John B. Windberg Database Administrator Imagine Media Inc. jonwa@imaginemedia.com