On 26/4/62 23:56, Jose Isaias Cabrera wrote:
this query. If you try ".expert -verbose", it will tell you the other
This is the output from --verbose
sqlite> .expert --verbose
sqlite> SELECT a.*,sum(b.AnnualDossier) as Dossier FROM Project_List AS a
...> LEFT JOIN Project_ABT_Budget AS b ON a.ProjID = b.ProjID
...> AND
...> b.InsertDate =
...> (SELECT MAX(InsertDate) FROM Project_ABT_Budget WHERE b.ProjID =
ProjID)
...> WHERE a.ProjID IN
...> (
...> SELECT a.ProjID FROM Project_List WHERE 1=1
...> AND lower(a.Manager) LIKE '%diggs%'
...> ) AND a.InsertDate =
...> (SELECT MAX(InsertDate) FROM Project_List WHERE ProjID = a.ProjID)
...>
...> GROUP BY a.ProjID;
-- Candidates -----------------------------
(null)
...
Maybe Candidates should say something else other than (null).
That means it couldn't even come up with anything to try - you already
have indexes for all WHERE constraints an ORDER/GROUP BY terms in the
query. It should probably say "(no candidates found)", or something
along those lines.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users