> In short, you cannot assume conditions are processed left-to-right, > including JOIN conditions.
I admit that i haven't checked the snadart but I did check other engines and they evaluate from left to right. I think that long time ago I'v read in a standart that 3 table join is basicly equivalent to joining first 2 tables and than third (I'm not sure though) which implies left to right. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users