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 a
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
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? (Basic
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 exclud