query: SQL Difference Between WHERE and ON for Joins
positive_passages.docid: 16178
positive_passages.text: SQL JOIN - WHERE clause vs. ON clause
negative_passages.docid: 64577
negative_passages.text: SQL JOIN Syntax in MS SQL
negative_passages.docid: 11808
negative_passages.text: Why would someone use WHERE 1=1 AND  in a SQL clause?
negative_passages.docid: 7488
negative_passages.text: Inner join vs Where
negative_passages.docid: 18890
negative_passages.text: INSERT INTO vs SELECT INTO
negative_passages.docid: 100646
negative_passages.text: MySQL - Using COUNT(*) in the WHERE clause
negative_passages.docid: 68780
negative_passages.text: Limit on the WHERE col IN (...) condition
negative_passages.docid: 120837
negative_passages.text: Difference between EXISTS and IN in SQL?
negative_passages.docid: 69613
negative_passages.text: How do I add a condition to a query?
negative_passages.docid: 152400
negative_passages.text: "at which time" vs. "at what time"
negative_passages.docid: 66324
negative_passages.text: Performance of string comparison vs int join in SQL
negative_passages.docid: 77241
negative_passages.text: What is the syntax for an inner join in LINQ to SQL?
negative_passages.docid: 130567
negative_passages.text: Difference between INNER JOIN and WHERE?
negative_passages.docid: 26515
negative_passages.text: Using a WHERE ___ IN ___ statement
negative_passages.docid: 141355
negative_passages.text: SQL left join vs multiple tables on FROM line?
negative_passages.docid: 97835
negative_passages.text: Difference between .on() functions calls
negative_passages.docid: 9555
negative_passages.text: MySQL how to join tables on two fields