Saturday, 31 August 2013

SQLite returning wrong data

SQLite returning wrong data

I have 22 rows of data. But after running this query
select
AUTHORS_ABSTRACT.ABSTRACTSITEM_ID,
ABSTRACT_AFFILIATION.AFFILIATION_NUMBER,
AUTHORS_AFFILIATE.ABSTRACTAUTHOR_ID
from
ABSTRACT_AFFILIATION,
AUTHORS_AFFILIATE,
AUTHORS_ABSTRACT
where ABSTRACT_AFFILIATION._id =
AUTHORS_AFFILIATE.ABSTRACTAFFILIATION_ID
and AUTHORS_ABSTRACT.ABSTRACTAUTHOR_ID = AUTHORS_AFFILIATE.ABSTRACTAUTHOR_ID
ORDER BY AUTHORS_ABSTRACT.ABSTRACTSITEM_ID ASC
and If you need the .db file here is my db file . So, after running this
query I get 36 rows of data.
So, my question is Why it returns 36 rows, even 22 rows data exist in the
database.

No comments:

Post a Comment