PostgreSQL 别名
AS 给列或表起临时别名；表别名在多表 JOIN 时让 SQL 更简洁。
Key PointsPostgreSQL,AS,别名
讲解
AS 给列或表起临时别名；表别名在多表 JOIN 时让 SQL 更简洁。
示例
SQL
SELECT c.name AS company_name, o.amount
FROM company AS c JOIN orders AS o ON o.person = c.id;讲解
AS 给列或表起临时别名；表别名在多表 JOIN 时让 SQL 更简洁。
示例
SQL
SELECT c.name AS company_name, o.amount
FROM company AS c JOIN orders AS o ON o.person = c.id;