Finding the "most recent" related record?

[Brian Dunning]

I have a table of questions, and a table of answers. Each question  
has a related answer record for each person who has answered that  
question, and each answer is timestamped. How do I find a list of  
questions where the MOST RECENT answer is less than 30 days ago?  
(Basically trying to exclude questions that nobody has answered  
lately.) Thanks.  :)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]