On Wednesday, May 30, 2012 10:14:22 f.h. Charles Samuels wrote: > sqlite> select Name from Employee join Uniform on > Employee.name=Uniform.employeename; > Joe > Dave > sqlite> explain query plan select Name from Employee join Uniform on > Employee.name=Uniform.employeename; > 0|0|0|SCAN TABLE Employee (~1000000 rows) > 0|1|1|SEARCH TABLE Uniform USING COVERING INDEX sqlite_autoindex_Uniform_1 > (employeename=?) (~1 rows)
I mean "left outer join" here! sqlite> select Name from Employee left outer join Uniform on Employee.name=Uniform.employeename; Joe Steve Eric Dave sqlite> explain query plan select Name from Employee left outer join Uniform on Employee.name=Uniform.employeename; 0|0|0|SCAN TABLE Employee (~1000000 rows) 0|1|1|SEARCH TABLE Uniform USING COVERING INDEX sqlite_autoindex_Uniform_1 (employeename=?) (~1 rows) Charles (can never proofread enough.) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users