From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Simon Slavin <slav...@bigfraud.org> 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 <kmedc...@dessus.com> 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.
Hey guys, So what are the semantics of the predicate on the join versus the where clause? Just curious... Thanks a lot Keith and Simon! jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users