The type of join is unaffected by the type of table (native or virtual). Pretend all tables are native SQLite tables.
You must return correct results from your xBestIndex function for the cost-based optimiser to select an efficient plan. -----Ursprüngliche Nachricht----- Von: Micka [mailto:mickamus...@gmail.com] Gesendet: Montag, 07. Juli 2014 17:11 An: General Discussion of SQLite Database Betreff: [sqlite] sqlite & INNER JOIN & vtable Hi, In my case I've a normal sqlite table : toto and an vtable : special This is the typical request that I have : SELECT toto.id, toto.name, special.info FROM toto INNER JOIN special ON ( special.id = toto.specialid AND toto.test == TRUE ) I don't know if I should use LEFT JOIN, RIGHT JOIN or INNER JOIN in this case .... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users