oh, that makes sense.  Thanks for clarifying.

Sam


-----------------------------------------------------------------
We're Hiring! Seeking passionate Flex or C# developer in the Washington
D.C. Contact care...@blinemedical.com


On Wed, Oct 31, 2012 at 10:18 AM, Richard Hipp <d...@sqlite.org> wrote:

> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to