Thanks, This syntax works but it is not documented... it looks like a short hand for a subquery, interesting !.
Mathieu -----Message d'origine----- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Simon Davies Envoyé : lundi 19 mars 2012 14:24 À : General Discussion of SQLite Database Objet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On 19 March 2012 13:05, Pavel Ivanov <paiva...@gmail.com> wrote: >> According to the documentation on SELECT statements >> http://www.sqlite.org/lang_select.html >> It seems possible to write join chains as A join (B join C). (using a >> '(' join-source ')' single-source ) > ... >> It seems that parsing is ok (no syntax error) but sources in the sub join >> can't be used outside the parenthesis. >> >> Could you confirm this is a bug ? or did I miss something ? > > So there's no problem in documentation and you can indeed write join > chains using parenthesis. Also there's no bug in SQLite because > (according to documentation) join-source with parenthesis is > considered a single-source and as a consequence you can't link to some > details of this single-source outside of parenthesis. Maybe MS SQL > Server and Oracle provide an extension to do that, but SQLite doesn't. > > So we can't confirm a bug and you didn't miss anything. You can file a > bug with the application generating your original query. > > > Pavel Maybe what the application should be doing: SELECT subjoin.OrderID FROM Customers INNER JOIN (Orders LEFT OUTER JOIN InternationalOrders ON Orders.OrderID = InternationalOrders.OrderID ) AS subjoin ON Customers.CustomerID = subjoin.CustomerID WHERE 'ALFKI' = Customers.CustomerID Regards, Simon _______________________________________________ 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