On 15 Apr 2013, at 9:40pm, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 4/15/2013 4:31 PM, Simon Slavin wrote: >> I also note this: >> >>> WHERE ((([Object_Types].[Object_Type])="DTC")) >> >> This is technically incorrect. It should use single quotes around DTC, not >> double quotes. > > Actually - does any of the tables participating in the statement have a > column named DTC, by any chance? Perhaps DTC_Status? If so, then your WHERE > clause doesn't mean what you think it means: it's not a filter, but another > join. That would explain the query plan. Ahhhahahaha ! I made an assumption. Bad Simon. No cookie. Thanks, Igor. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
