SELECT
a.foo
b.bar
c.foobar
FROM tableOne AS a
INNER JOIN tableTwo AS b ON a.pk = b.fk
LEFT JOIN tableThree AS c ON b.pk = c.fk
WHERE a.foo = 'something'
AND c.foobar = 'somethingelse'
SELECT
a.foo
b.bar
c.foobar
FROM tableOne AS a
阅读背景：
左连接变成内连接
来源：互联网
分享到：
