-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
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 practice to
use rowid's like you are doing. If you had inserted the id it would be a
different story.
*Jim Dodgen*
On Thu, Nov 2, 2017 at 5:26 PM, Keith Medca
I think your query is in error. Amongst other things, tou have the same
condition listed twice:
SELECT cl.ProjID FROM ProjectsMine cl JOIN ProjectsALL ls ON
(
cl.id = ls.id AND
cl.login = 'id0' AND
cl.id = ls.id AND DUPLICATE
cl.XtraB != ls.XtraB
);
You cannot
8 matches
Mail list logo