Hi there! My colleagues and I are trying to understand the role of ON constraints vs WHERE clauses in JOINs. It seems both of the following work, but I’m not really sure why:
Query A: SELECT * FROM tab1 LEFT JOIN tab2 ON tab1.x=‘constant’; Query B: SELECT * FROM tab1 LEFT JOIN tab2 ON tab1.x=tab2.x WHERE tab1.x=‘constant’; Is there a difference between the two (function and performance)? Is there an advantage to putting WHERE-type filtering in the ON constraint vs leaving it in the WHERE clause for LEFT JOINs? Thanks! Ben _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
