Organizational Research By

Surprising Reserch Topic

INNER JOIN ON vs WHERE clause


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.primarykey
    AND (some other conditions)
Or else:

SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1 INNER JOIN table2
    ON table1.foreignkey = table2.primarykey
WHERE
    (some other conditions)
Are those two worked on the same way by MySQL?
asked Jun 9, 2015 in MYSQL by rajesh
0 votes
35 views



Related Hot Questions



Government Jobs Opening


...