Re: [sqlite] Question on SQL query optimization with joins

2006-06-15 Thread Dennis Cote
Bob Dankert wrote: I have been pondering an issue for a while regarding the separation of query conditions from the join condition and the where condition of the query. All I have been able to find on this matter is general text "use the ON clause for conditions that specify how to join tables,

[sqlite] Question on SQL query optimization with joins

2006-06-14 Thread Bob Dankert
I have been pondering an issue for a while regarding the separation of query conditions from the join condition and the where condition of the query. All I have been able to find on this matter is general text "use the ON clause for conditions that specify how to join tables, and the WHERE clause