Igor Korot, on Wednesday, February 19, 2020 04:30 PM, wrote...
>
> Hi,
>
> On Wed, Feb 19, 2020 at 2:12 PM Jose Isaias Cabrera
> wrote:
> >
> >
> > Thanks, Keith. Darn it! GROUP BY and ORDER BY! Got it, it's working
> now. Thanks.
> >
> >
> >
> sqlite-users on b
dnesday, February 19, 2020 03:09 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] Why do I only get one record?
>
>
> 1) In the first two query's, why do you have a condition on the LHS table in
> the LEFT JOIN conditions?
> 2) In the last query, why do you have
Thanks, Keith. Darn it! GROUP BY and ORDER BY! Got it, it's working now.
Thanks.
From: sqlite-users on behalf of
Keith Medcalf
Sent: Wednesday, February 19, 2020 03:09 PM
To: SQLite mailing list
Subject: Re: [sqlite] Why do I only get one record
1) In the first two query's, why do you have a condition on the LHS table in
the LEFT JOIN conditions?
2) In the last query, why do you have a condition on the RHS table of the LEFT
JOIN in the WHERE clause?
These would seem to indicate that you are using a LEFT JOIN when you really do
not w
4 matches
Mail list logo