query: Is placing the filter condition inside the join on statement equivalent?
positive_passages.docid: 16178
positive_passages.text: SQL JOIN - WHERE clause vs. ON clause
negative_passages.docid: 148262
negative_passages.text: How can I do an UPDATE statement with JOIN in SQL Server?
negative_passages.docid: 117739
negative_passages.text: How to filter SQL results in a has-many-through relation
negative_passages.docid: 118970
negative_passages.text: How do I include nulls during comparisons in SQL Server?
negative_passages.docid: 114926
negative_passages.text: Reading Lookup Filter criteria from SObject field descriptions?
negative_passages.docid: 4094
negative_passages.text: What is the difference between "INNER JOIN" and "OUTER JOIN"?
negative_passages.docid: 154901
negative_passages.text: Simple Linq query has duplicated join against same table?
negative_passages.docid: 114214
negative_passages.text: How do I find records that are not joined?
negative_passages.docid: 156322
negative_passages.text: LINQ Inner-Join vs Left-Join
negative_passages.docid: 69613
negative_passages.text: How do I add a condition to a query?
negative_passages.docid: 77312
negative_passages.text: Is exporting to feature class the simplest way to make joins permanent?
negative_passages.docid: 1408
negative_passages.text: SQL JOIN vs IN performance?
negative_passages.docid: 68967
negative_passages.text: INNER JOIN ON vs WHERE clause
negative_passages.docid: 135857
negative_passages.text: Condition within JOIN or WHERE
negative_passages.docid: 121093
negative_passages.text: Join Query effects natural ordering
negative_passages.docid: 83110
negative_passages.text: JOIN versus EXISTS performance
negative_passages.docid: 125393
negative_passages.text: Confirm if sub-query is selective?