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
