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
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?
Hello.
If condition 'where the MOST RECENT answer is less than 30 days ago'
isn't the same as 'where some answer is less than 30 days ago' in your
case? I think they're equal. So the query is:
SELECT DISTINCT q.question
FROM questions q
INNER JOIN answers a ON a.qid=q.id
WHERE dateago
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