On Wed, Oct 31, 2012 at 9:54 AM, Samuel Neff <srneff.li...@gmail.com> wrote:
> We wrote a query and intended to use a "natural" join but had a typo and > wrote "natrual" join instead. We were surprised this query was processed > without error and performed a cross join. > > Example: > sqlite> select * from a natrual join b; > The "natrual" became an alias for table "a". As if you had written: SELECT * FROM a AS natrual JOIN b; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users