SQL join 和 where 等多条件连用

143 阅读 0 评论 95 点赞

我是靠谱客的博主友好金针菇，这篇文章主要介绍SQL join 和 where 等多条件连用，现在分享给大家，希望可以做个参考。

本文转部分补充

For simplicity, assume all relevant fields are NOT NULL.

You can do:

复制代码

1
2
3
4
5
6
7
SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1, table2
WHERE
    table1.foreignkey = table2.primarykey
    AND (some other conditions)

Or else:

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
复制代码SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1 INNER JOIN table2
    ON table1.foreignkey = table2.primarykey
WHERE
    (some other conditions)SELECT
    table1.this, table2.that, table2.somethingelse
FROM
    table1 INNER JOIN table2
    ON table1.foreignkey = table2.primarykey
WHERE
    (some other conditions)
复制代码Order 条件放在最后 可以理解为先选择完然后sortOrder 条件放在最后 可以理解为先选择完然后sort