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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
