On Tue, Apr 5, 2011 at 8:30 AM, Vitali Kiruta <kir...@gmail.com> wrote:

> Hi everybody,
>
> I hope somebody could clarify this for me. According to the sql
> grammar definition, the single-source production
> does not allow the table-alias after the join-source
>
> See http://www.sqlite.org/syntaxdiagrams.html#single-source
>
> However, when I'm trying to run this query it works just fine:
>
> select t.* from (t1 join t2) as t;
>
> Is it an oversight in the definition or am I missing something?
>

This currently works.  But because it is not part of the language spec, we
do not guarantee that we will continue to support it.


>
> Thanks in advance
> Vitali
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to