I have two tables, A and B, where the entries in B are connected to A through a left join. Thus there may be several entries in B for each post in A.
Now I would like to select the two latest posts in A and all the corresponding posts in B. I tried something like SELECT fields FROM A LEFT JOIN B O
.ID
DESC;
> -Original Message-
> From: Cybot [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 1:05 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Limiting left joins
>
>
> > I have two tables, A and B, where the entries in B are
> connected to A
> > th
Hello,
I have two tables, A and B, where the entries in B are connected to A through a left
join. Thus there may be several entries in B for each post in A.
Now I would like to select the two latest posts in A and all the corresponding posts
in B. I tried something like SELECT fields FROM A LEF
