将连接添加到Postgresql查询后，该查询无法按预期工作
将连接添加到Postgresql查询后，该查询无法按预期工作
提问于 2018-03-12 16:53:33
当我进行这样的查询时：
SELECT payment.customer_id, COUNT(payment.customer_id), SUM(payment.amount)
FROM payment
GROUP BY customer_id
ORDER BY SUM(payment.amount) DESC
LIMIT 10它工作得很好，但是当我尝试连接另一个表中的字段时，它失败了：
SELECT payment.customer_id, customer.email COUNT(payment.customer_id), SUM(payment.amount)
FROM payment
GROUP BY customer_id
ORDER BY SUM(payment.amount) DESC
LIMIT 10
JOIN customer
ON payment.customer_id = customer.customer_id我做错了什么？如何从customer表添加email列？
Stack Overflow用户
发布于 2018-03-12 16:57:54
为了加入，你必须在From关键字之后使用它，如下所示
Select Table1.customer_id,Table1.email,Table1.amt from (
SELECT payment.customer_id, customer.email COUNT(payment.customer_id) email, SUM(payment.amount) amt
FROM payment
GROUP BY customer_id
ORDER BY SUM(payment.amount) DESC
LIMIT 10
) Table1 JOIN customer
ON Table1.customer_id = customer.customer_id页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/49231258
复制相关文章
相似问题
腾讯云开发者
