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