On 28 Apr 2017, at 12:31am, Joseph L. Casale <jcas...@activenetwerx.com> wrote:

> So what are the semantics of the predicate on the join versus the where 
> clause?
> Just curious...

SELECT <columns from both tables> FROM <name of primary table>
JOIN <name of secondary table> WHERE <which records in secondary table you want>

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to