It seems to me I ought to be able to construct a query, probably using sub-SELECTs), that would do what I want. I have a table that looks roughly like this:
CREATE TABLE prod (prod_num INTEGER UNIQUE, prod_title VARCHAR(255), updated DATE) UNIQUE PRIMARY KEY (prod_num); In this table there might be two records that have the same title, with different values for prod_num and updated. I want to find the prod_nums for the older of the two records. I know when the new ones were updated, so that can be a literal. I just haven't been able to think it through. Using NOT IN with the subquery gave me the inverse of what I wanted. This shouldn't be impossible to do, Access has a "find duplicates" wizard; but come to think of it, that lists both records and I never tried to limit it to just the older. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
