On 30 Oct 2009, at 4:07pm, Kristoffer Danielsson wrote: > "Some database engines like SQL Server decide which table is the > outer table and which table is the inner table" > > > How do I simulate that behavior in SQLite? A misformed SQL statement > from the user results in unacceptable lockups...
SQLite already makes that decision. If you want to enforce which way it decides, you specify INNER JOIN or OUTER JOIN just as you do in most SQL engines: <http://www.sqlite.org/lang_select.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users