postgresql 左外连接列不存在

Question

我是 postgres 的新手。我有一个问题

SELECT * FROM orders
LEFT OUTER JOIN order_details ON order_details.orderid= orders.orderid 

出现错误

SQL error:

ERROR:  column order_details.orderid doesn't exist
LINE 2:       LEFT OUTER JOIN order_details ON order_details.orderid...
                                           ^
In statement:

SELECT COUNT(*) AS total FROM (SELECT * FROM orders
 LEFT OUTER JOIN order_details ON order_details.orderid= orders.orderid) AS sub

我的查询中缺少什么？先谢谢

Answer 1

Postgres 区分大小写。您的 SQL 语句必须大小写正确，如果表名或列​​名不是小写，则必须将其括在双引号中。 (如下图)

  SELECT * FROM orders
LEFT OUTER JOIN order_details ON order_details."OrderID"= orders.orderid