Paul Lautman wrote:
> pillepop2003@yahoo.de wrote:
> > Hey guys!
> > I'm just coding a little forum application and have some trouble with
> > my "thread-overview" page.
> > I want to list a table with the following information:
> >
> > Thread_title | username_of_last_post | datetime_of_last_post
> >
> > My schema is as follows:
> >
> > thread (thread_id, thread_title, ...)
> > post (post_id, thread_id, user_id, date_created, ...)
> > user (user_id, name, ...)
> >
> > THE PROBLEM:
> > As my provider is still using mysql4.0x without subselects, i want to
> > do this in one query BUT I HAVE NO CLUE HOW TO DO IT!!! In general, it
> > looks like a simple JOIN operation, but how do I get mysql to show
> > only the username / datetime of THE LAST post of EACH thread???
> >
> > Any help is highly appreciated
> > Thanks a lot!!
> >
> > Philipp
>
> You need what I call the "Strawberry Query"
> See the pattern for it in my response on this thread:
> http://tinyurl.com/yex7s2

:-) FWIW, i call it the Karwin query!

Happy New Year!