strawberry wrote:

> 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!
Happy New Year to you too.
I've never come across a post from Bill where he has used this method,
but I have seen a couple that you did. Maybe I should call it the
Karwin->Strwaberry query?