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.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
