Is the following join equivalent?
125094
Which table is the "left" in this query
86478
SQL query that concatenates values from duplicate rows in a single table
120518
Explanation of self-joins
68346
What's the best way to join on the same table twice?
97639
Combine multiple rows into one MySQL Join
52570
How to do an update + join in PostgreSQL?
108832
Is a join optimized to a where clause at runtime?
142592
Simple SQLServer PIVOT/Transposed query, how to write?
96918
How to use index for simple time range join?
18521
One-to-many joins in QGIS
68967
INNER JOIN ON vs WHERE clause
35704
How do you join on the same table, twice, in mysql?
21830
How to do joins in LINQ on multiple fields in single join
130567
Difference between INNER JOIN and WHERE?
84051
Simplest way to do a recursive self-join?
1408
SQL JOIN vs IN performance?
146592
Is there a faster way to get UNION ALL behavior in Postgres?