On Fri, Mar 14, 2008 at 5:46 PM, Jonas Sandman <[EMAIL PROTECTED]>
wrote:
> Isn't proper SQL
>
>  select * from (select user.id from user ) blah where blah.id=1 ; ?

>From www.sqlite.org, sql syntax, select statement:

sql-statement ::= SELECT [ALL | DISTINCT] result [FROM *table-list*]

*table-list* ::= *table *[join-op table join-args]*

*table *::= table-name [AS alias] |
*( select ) *[AS alias]

As you can see from the sqlite definition language it qualifies as valid
sql.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to