Quote:
Originally Posted by davidfor
I'm not sure what you mean by "one JOIN". I've written SQL against the SQLite database in the Kobo ereaders that has joined more than two tables and used INNER and OUTER. SQLite does have some short comings compared to a full relational database. But, it's big feature is that it is self-contained. It doesn't need a separate process running for the database and is relatively lightweight in resources used. That's probably why it is popular for small devices. But, calibre is using it for its database and Firefox uses it for the several things.
|
Thank you David, hope will be possible in future KOBO version to import the SONY highlights, I have thousands of notes and do not buy KOBO, just because does not support importing sony highlights, well also i do not like PDF dictionary and the lack of android open, but I had bought it if could export the highlights, considering they took over sony ereaders.
anyway thank you again, this is what i mean:
http://www.tutorialspoint.com/sqlite...sing_joins.htm
SQL standard defines three types of OUTER JOINs: LEFT, RIGHT, and FULL but SQLite only supports the LEFT OUTER JOIN