sql - INNER JOIN ON vs WHERE clause - Stack Overflow
For simplicity, assume all relevant fields are NOT NULL. You can do: SELECT table1.this, table2.that, table2.somethingelse FROM table1, table2 WHERE table1.foreignkey = table2.primary... ... Others have pointed out that INNER JOIN helps human readability ...