So simple - I was trying to WAY overcomplicate it. Thanks. :)
On Aug 17, 2005, at 10:05 AM, Jon Drukman wrote:
Brian Dunning wrote:
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. :)
i've made up the table and column names since you didn't provide them.
select *
from
question q
join answer a on q.question_id = a.question_id
where
a.answer_date > date_sub(now(), interval 30 day)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
