[sqlite] SELECT table list issue

[Terrence Brannon]

[1] I no longer work for directsynergy.com. Some may wonder why I state 
this. If you don't know, it doesn't matter.

[2] The following SQL fails because the FROM clause is enclosed in 
parentheses:

sqlite> SELECT 
dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2 FROM 
(dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id) WHERE   
dbixrs1.id IN (2, 5, 10);
SQL error: near "dbixrs1": syntax error

Is it unreasonable to request that parentheses be supported around the 
FROM clause? Postgres supports it.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]