Re: [sqlite] SQL join syntax

2017-04-27 Thread Keith Medcalf
On Thursday, 27 April, 2017 17:31, Joseph L. Casale inquired: > Hey guys, > So what are the semantics of the predicate on the join versus the where > clause? > Just curious... When the joins are only equijoins (inner joins) of any type: SELECT FROM JOIN ON JOIN ON WHERE is syntactic s

Re: [sqlite] SQL join syntax

2017-04-27 Thread Igor Tandetnik
On 4/27/2017 7:15 PM, Joseph L. Casale wrote: Hey guys, Need a pointer some join syntax. I have a couple where TableA is one to many on TableB. TableB structure is three columns Id,Key,Value. For each row I select in Table, I join TableB several times for each Key whose value I want in the singl

Re: [sqlite] SQL join syntax

2017-04-27 Thread Simon Slavin
On 28 Apr 2017, at 12:31am, Joseph L. Casale wrote: > So what are the semantics of the predicate on the join versus the where > clause? > Just curious... SELECT FROM JOIN WHERE Simon. ___ sqlite-users mailing list [email protected]

Re: [sqlite] SQL join syntax

2017-04-27 Thread Joseph L. Casale
From: sqlite-users on behalf of Simon Slavin Sent: Thursday, April 27, 2017 5:26 PM To: SQLite mailing list Subject: Re: [sqlite] SQL join syntax   > On 28 Apr 2017, at 12:21am, Keith Medcalf wrote: > >> SELECT TableA.ColA Name, B.Value BV, C.Value CV >> FROM TableB >

Re: [sqlite] SQL join syntax

2017-04-27 Thread Simon Slavin
On 28 Apr 2017, at 12:21am, Keith Medcalf wrote: > SELECT TableA.ColA Name, B.Value BV, C.Value CV > FROM TableB I think Keith means "FROM TableA" on that second line. The rest looks perfect. Simon. ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] SQL join syntax

2017-04-27 Thread Keith Medcalf
#x27;sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -Original Message- > From: sqlite-users [mailto:[email protected]] > On Behalf Of Joseph L. Casale > Sent: Thursday, 27 April, 2017 17:15 > To: '[email protected]' > Subject: [sqlite] SQL

Re: [sqlite] SQL join syntax

2017-04-27 Thread Joseph L. Casale
> Works fine when BAR and BAZ values exist in TableB.Key. Move the predicate on to the join it seems? ___ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL join syntax

2017-04-27 Thread Joseph L. Casale
Hey guys, Need a pointer some join syntax. I have a couple where TableA is one to many on TableB. TableB structure is three columns Id,Key,Value. For each row I select in Table, I join TableB several times for each Key whose value I want in the single row result. How do you construct the join and