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 <[email protected]> wrote: > > >On 12 Mar 2013, at 7:24pm, [email protected] 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 >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
