Re: [sqlite] create view doesn't work

2013-03-12 Thread James K. Lowden
On Tue, 12 Mar 2013 19:57:26 + Simon Slavin 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") > >

Re: [sqlite] create view doesn't work

2013-03-12 Thread Simon Slavin
On 12 Mar 2013, at 9:12pm, ven...@intouchmi.com wrote: > 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. You're welcome. > It was the second select, which I rewrote, that I

Re: [sqlite] create view doesn't work

2013-03-12 Thread veneff
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

Re: [sqlite] create view doesn't work

2013-03-12 Thread Simon Slavin
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

Re: [sqlite] create view doesn't work

2013-03-12 Thread veneff
As a follow up, what I meant to ask is why it doesn't work. I rewrote the original select: SELECT "Categories"."Category_Name", "Strings"."Long_Text", "Units"."Long_Units", "Limits"."Lower_Limit", "Limits"."Upper_Limit" FROM Objects INNER JOIN (Categories INNER JOIN Object_Categories ON

Re: [sqlite] create view doesn't work

2013-03-12 Thread veneff
Dominique, Thanks for your response and for breaking down the select into manageable pieces! According to the limits info, there should be no problem with the # of terms in that select statement (< 500). There are hundreds of these predefined queries that I am extracting out of the MS access

Re: [sqlite] create view doesn't work

2013-03-12 Thread Dominique Devienne
I'm no expert, but I think your problem comes from the excessive parentheses you are using. Below's a little experiment that reproduces your syntax, with its error, and provides an alternative simpler syntax that works. --DD C:\Users\DDevienne>sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05