[snip] I have a table that contains a item_id field (non unique index) id field and a date field.
How would you go about selecting rows from the table (single row for each item_id with the earliest date field for that item_id). If I use group by item_id the date field will be whatever the first date field it had, so ordering by it at that point will not yeald the intended results. [/snip] Use MAX(date field) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
