PostgreSQL JOIN
JOIN 连接多表：INNER/LEFT/RIGHT/FULL CROSS；连接条件写 ON。
Key PointsPostgreSQL,JOIN,连接,INNER,LEFT,FULL
讲解
JOIN 连接多表：INNER/LEFT/RIGHT/FULL CROSS；连接条件写 ON。
示例
SQL
SELECT c.name, o.amount
FROM company c
LEFT JOIN orders o ON o.person = c.id;Output
name | amount
------+--------
Tom | 120.00讲解
JOIN 连接多表：INNER/LEFT/RIGHT/FULL CROSS；连接条件写 ON。
示例
SQL
SELECT c.name, o.amount
FROM company c
LEFT JOIN orders o ON o.person = c.id;Output
name | amount
------+--------
Tom | 120.00