Virtual tables are just like any other tables. The kind of join is the matter
of you expectations from the query outcome. > 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
