On Nov 11, 2011, at 3:03 PM, Fabian wrote: > It returns the same results, but it doesn't seem much faster. Is there any > performance difference to be expected from using IN instead of JOIN, or > does SQLite internally rewrite JOIN queries to something similar as IN, > which would explain they perform nearly the same?
They should be equivalent in terms of cost. That said, you might want to use the 'exists' clause instead for the sake of clarity. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users