-Original Message-
From: Keith Medcalf
Sent: Friday, November 3, 2017 12:49 AM
To: SQLite mailing list
Subject: Re: [sqlite] Missing data on SELECT
Well that is a totally different thing. Of course, in your sample data
id-10 DOES NOT exist in ProjectMine, so you will never see id=10 no
Thanks.
-Original Message-
From: Simon Slavin
Sent: Friday, November 3, 2017 12:40 AM
To: SQLite mailing list
Subject: Re: [sqlite] Missing data on SELECT
On 3 Nov 2017, at 4:32am, jose isaias cabrera wrote:
It's a long story, but what I would like to SELECT is the id or ids
rsday, 2 November, 2017 22:26
>To: SQLite mailing list
>Subject: Re: [sqlite] Missing data on SELECT
>
>
>You're right. Apologies. The right SELECT would be,
>
>SELECT cl.ProjID FROM ProjectsMine cl JOIN ProjectsALL ls ON
>(
> cl.id = ls.id AND
> cl.login =
On 3 Nov 2017, at 4:32am, jose isaias cabrera wrote:
> It's a long story, but what I would like to SELECT is the id or ids that have
> different XTraB between ProjectsMine and ProjectsALL, and also list the id,
> or ids, that exists in ProjectsMine and not on ProjectsALL.
Do it as two separa
sMine.
-Original Message-
From: Jim Dodgen
Sent: Thursday, November 2, 2017 11:43 PM
To: SQLite mailing list
Subject: Re: [sqlite] Missing data on SELECT
You are inserting rows with ProjID but not the primary key "id" which is
rowid and automatically created. I think it is not a good
ope this
explains everything. Thanks for the help.
-Original Message-
From: Keith Medcalf
Sent: Thursday, November 2, 2017 8:26 PM
To: SQLite mailing list
Subject: Re: [sqlite] Missing data on SELECT
I think your query is in error. Amongst other things, tou have the same
cond
eaven says
> a lot about anticipated traffic volume.
>
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of jose isaias cabrera
> >Sent: Thursday, 2 November, 2017 16:02
> >To: SQLite mailing list
>
.@mailinglists.sqlite.org] On Behalf Of jose isaias cabrera
>Sent: Thursday, 2 November, 2017 16:02
>To: SQLite mailing list
>Subject: [sqlite] Missing data on SELECT
>
>
>Greetings.
>
>Apologies for the long email, or long set of data. I have these two
>tables in two d
Greetings.
Apologies for the long email, or long set of data. I have these two tables in
two different database files, but for easy setup, I have place them in the same
DB. Having these data,
CREATE TABLE ProjectsALL
(
id integer primary key, ProjID integer, login, cust, proj, XtraB
);
IN
9 matches
Mail list logo