Re: [sqlite] Missing data on SELECT

2017-11-03 Thread jose isaias cabrera
-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

Re: [sqlite] Missing data on SELECT

2017-11-03 Thread jose isaias cabrera
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

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread Keith Medcalf
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 = 

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread Simon Slavin
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

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread jose isaias cabrera
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

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread jose isaias cabrera
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

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread Jim Dodgen
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

Re: [sqlite] Missing data on SELECT

2017-11-02 Thread Keith Medcalf
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