Solsberry, Glendon wrote: > Is there a way to select some data from a table where the date field is > the MIN() of that date column? Aka, if I have 100 rows of data, and the > MIN() date is 1/1/2000, then I want to select the data that is from > 1/1/2000. Can this be done without doing a multi-table join, or is that > the only way to handle this??? >
This sounds similar to what's described here: http://www.mysql.com/doc/e/x/example-Maximum-row.html Hope this helps, Richard -- / \ Richard M Davis / Digital Archives \ University of London Computer Centre / Tel: +44 (0) 20 7692 1350 \ mailto: [EMAIL PROTECTED] / --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php