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
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 >

Re: [sqlite] Missing data on SELECT

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

[sqlite] Missing data on SELECT

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