On Mon, Sep 8, 2008 at 9:49 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Sun, Sep 7, 2008 at 6:09 AM, Gregory Stark <[EMAIL PROTECTED]> wrote:
>> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
>>
>>> I want to get a list looking like
>>>
>>> forum idthread_id post_id
>>> 1 6
On Sun, Sep 7, 2008 at 6:09 AM, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
>
>> I want to get a list looking like
>>
>> forum idthread_id post_id
>> 1 6 443
>> 2 9 123
>> 3 3 557
> ...
>> It all
In article <[EMAIL PROTECTED]>,
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> or maybe not and I'm just not getting it.
> So here's the scenario:
> I have 3 tables
> forum: with primary key "id"
> forum_thread: again primary key "id" and a foreign key "forum_id" referencing
> th primary key
On Sunday 07 September 2008, Gregory Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I want to get a list looking like
> >
> > forum idthread_id post_id
> > 1 6 443
> > 2 9 123
> > 3 3 557
>
> ...
>
> > It all boils down
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> I want to get a list looking like
>
> forum idthread_id post_id
> 1 6 443
> 2 9 123
> 3 3 557
...
> It all boils down to me not being able to come up with a query that gives me
> the latest
or maybe not and I'm just not getting it.
So here's the scenario:
I have 3 tables
forum: with primary key "id"
forum_thread: again primary key "id" and a foreign key "forum_id" referencing
th primary key of the forum table
forum_post: again primary key "id" with a forign key "thread_id" referen
