SQL join 和 where 等多条件连用

本文转 部分补充

For simplicity, assume all relevant fields are NOT NULL.

You can do:

SELECT    table1.this, table2.that, table2.somethingelseFROM    table1, table2WHERE    table1.foreignkey = table2.primarykey    AND (some other conditions)

Or else:

SELECT    table1.this, table2.that, table2.somethingelseFROM    table1 INNER JOIN table2    ON table1.foreignkey = table2.primarykeyWHERE    (some other conditions)
Order 条件放在最后 可以理解为先选择完然后sort