INNER JOIN ON vs cláusula WHERE

Question

Jun 19, 2009, 06:16 PM

INNER JOIN ON vs cláusula WHERE

Para simplificar, suponha que todos os campos relevantes sejamNOT NULL.

Você pode fazer:

<code>SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1, table2
WHERE
    table1.foreignkey = table2.primarykey
    AND (some other conditions)
</code>

Se não:

<code>SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1 INNER JOIN table2
    ON table1.foreignkey = table2.primarykey
WHERE
    (some other conditions)
</code>

Esses dois trabalham da mesma maneiraMySQL?