> -----Original Message----- > what we want is the value for the name field corresponding to the row > with the most recent close_date.
Based on that comment, I'd select name from TD order by close_date DESC limit 1 > > something like this: > > select max(close_date), symbol, name from TD where symbol in > (<list of > characters>) group by symbol; > > this returns the max close_date value, but the name that is > returned is > garbage and seems to point to the earliest row in the table. > > any suggestions? > > jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]