> It has LEFT JOIN and does not have RIGHT JOIN. Why? Because RIGHT can be made > out of LEFT by swapping order of tables.
The paradigma of SQL is to let the user describe what he wants to do, not to think about how to describe the problem so that the database system does understand. The lack of RIGHT JOIN, FULL INNER/OUTER JOIN, (full) ALTER TABLE, missing geospatial functions, etc. is a huge disadvantage, not an advantage! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
