-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Dan Kennedy
Sent: woensdag 18 december 2013 16:23
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bug where query does not give a result while it should
>> Are
On 12/18/2013 10:10 PM, Harmen de Jong - CoachR Group B.V. wrote:
We have found a query that does not give a result, while it should.
The query is:
select id
from productionentry
where id NOT IN (select productionentryid from zentry)
AND examid=12581;
There are rows in the table
We have found a query that does not give a result, while it should.
The query is:
select id
from productionentry
where id NOT IN (select productionentryid from zentry)
AND examid=12581;
There are rows in the table productionentry for which the id does not exist in
the column productionentryid
3 matches
Mail list logo
