[thelist] SQL- grouping and dates
Chris Evans
chris at fuseware.com
Tue Apr 3 14:30:04 CDT 2001
Here's a little better example of a thread I want to pull back:
Root Message Updated Subject
---------------------------------------------
abc abc 04/01/2001 04:00 Subject A
rgh rgh 04/01/2001 06:03 Subject B
abc gha 04/01/2001 12:00 RE: Subject A
abc 1jr 04/02/2001 06:03 RE: Subject A
rgh jus 04/03/2001 04:10 RE: subject B
rgh jiu 04/03/2001 11:05 RE: Subject B
abc qwe 04/03/2001 13:13 Changed sbject, same thread
Note that the root and message column are the same for the original mesage
posted in that thread.
What I'm looking for is this result set:
A (Subject A) has 4 messages, the most recent updated at 04/03/2001 13:13
B (Subject B) has 3 messages, the most recent updated at 04/03/2001 11:05
Pulling the subject for the original message posted in the thread, but
getting the date of the last message posted in the thread is where I'm
getting hung up.
Chris Evans
chris at fuseware.com
http://www.fuseware.com
More information about the thelist
mailing list