Re: [sqlite] Join-source issue when using sub '(' join-source ')'

users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Nico Williams Envoyé : lundi 19 mars 2012 16:10 À : General Discussion of SQLite Database Objet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On Mon, Mar 19, 2012 at 10:02 AM, TAUZIN Mathieu <mtau..

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On 19/03/2012 12:07 PM, TAUZIN Mathieu wrote: Thanks for your support ! SQL Ansi (and every major DB SqlServer,

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

bjet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On Mon, Mar 19, 2012 at 12:03:44PM +, TAUZIN Mathieu scratched on the wall: > Hi, > > According to the documentation on SELECT statements > http://www.sqlite.org/lang_select.html > It seems possible

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On Mon, Mar 19, 2012 at 12:03:44PM +, TAUZIN Mathieu scratched on the wall: > Hi, > > 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 ) > >

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On Mon, Mar 19, 2012 at 10:02 AM, TAUZIN Mathieu wrote: > Thanks, > > This syntax works but it is not documented... it looks like a short hand for > a subquery, interesting !. Join sources are like sub-queries. Look at the syntax. A sub-select specified in the join-source

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

 : 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 &g

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On 19 March 2012 13:05, Pavel Ivanov 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

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On 19 Mar 2012, at 12:51pm, TAUZIN Mathieu wrote: > Thanks for your response but my intent was to give rise to either an bug on > SQLite engine or an error (or maybe lack of precision) in the documentation. SQLite is fine. The documentation is accurate about what SQLite

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

> 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

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

. -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Simon Slavin Envoyé : lundi 19 mars 2012 13:20 À : General Discussion of SQLite Database Objet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On 19 Mar 2012, at 12

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

On 19 Mar 2012, at 12:03pm, TAUZIN Mathieu wrote: > Or without subjoin... > SELECT Orders.OrderID > FROM Customers > INNER JOIN Orders >ON Customers.CustomerID = Orders.CustomerID > LEFT OUTER JOIN InternationalOrders >ON Orders.OrderID =

[sqlite] Join-source issue when using sub '(' join-source ')'

Hi, 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 ) But on the well known NorthwindEF database this query ... SELECT Orders.OrderID FROM