On 28 Apr 2017, at 12:31am, Joseph L. Casale <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to