n the GROUP BY clause.
> >
> > --
> > The fact that there's a Highway to Hell but only a Stairway to Heaven
> says a lot about anticipated traffic volume.
> >
> > >-Original Message-
> > >From: sqlite-users On
> > >Behalf Of Jose Isaias
ay, 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 conditio
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
era
>Sent: Wednesday, 19 February, 2020 12:46
>To: SQLite mailing list
>Subject: [sqlite] Why do I only get one record?
>
>
>Greetings!
>
>Newbie here again... ;-)
>
>Please take a look at this query,
>
>sqlite> SELECT
> ...> a.ProjID, a.Start_date, a.F
Greetings!
Newbie here again... ;-)
Please take a look at this query,
sqlite> SELECT
...> a.ProjID, a.Start_date, a.Finish_Date, a.Target_Go_Live_Date,
...> a.BL_Start, a.BL_Finish, sum(b.AnnualDossier) as Dossier,
...> sum(b.Actuals) as ABTActual, sum(b.EAC) as ABTEAC
...> FROM
5 matches
Mail list logo