[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