Subject: #Form.Subject#
Message: #Form.Answer#
SELECT Threads.ThreadID, Threads.Name,
Count(Questions.ContactID) AS MessageCount,
Max(Questions.Date) As LastMessage
FROM Questions, Threads
WHERE Threads.ThreadID = Questions.ThreadID
AND Threads.Name Like '%#Title#%'
GROUP BY Threads.ThreadID, Threads.Name
HAVING Max(Questions.Date) > (Now()-#Age#)
ORDER BY Max(Questions.Date) DESC
Questions, Answers, and Information Bulletin Board
We have a new message board!!
Click here
Fabrics.net
Spokane, WA
Copyright, Fabrics.net
