Simon, The first select was the one that I retrieved from the MS Access DB. That one does NOT work in SQLite. Thanks for explaining why it wasn't acceptable by SQLite.
It was the second select, which I rewrote, that I was asking about. That one is acceptable by SQLite. My question was if the second one accomplished the same end results as the original (first) select. Vance on Mar 12, 2013, Simon Slavin <slav...@bigfraud.org> wrote: > > >On 12 Mar 2013, at 7:24pm, ven...@intouchmi.com wrote: > >> Is my rewrite the same as the original? > >No. You can't use this construction: > >> INNER JOIN (Categories INNER JOIN Object_Categories ON >> "Categories"."Category_ID"="Object_Categories"."Category_ID") > >The parser expects a table name immediately after INNER JOIN. Instead you are >opening >a bracket which is the way one would begin an expression. > >Simon. >_______________________________________________ >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