oh, that makes sense. Thanks for clarifying. Sam
----------------------------------------------------------------- We're Hiring! Seeking passionate Flex or C# developer in the Washington D.C. Contact [email protected] On Wed, Oct 31, 2012 at 10:18 AM, Richard Hipp <[email protected]> wrote: > On Wed, Oct 31, 2012 at 9:54 AM, Samuel Neff <[email protected]> > 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 > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
