MySQL 总和 +内连接查询

发布于 2024-12-02 17:35:40 字数 658 浏览 1 评论 0原文

问题：

表 1：id.1 |姓名：乔 |等等一些 | ...其他| ...数据
表2：id.X |号码。+1 123 555 9999 | useridfromtable1.1->将电话与 Joe 连接起来
表 3：id。 X |号码。+1 123 555 9999 | Calls.55

我需要一个连接 3 个表的查询，并且我只有表 1 中的 id (userid)。所以，我需要来自 userid ->拿起电话->从 table3 上的电话抢占电话。

回答：

SELECT t1.name,t1.id,t2.number,t3.calls
  FROM table1 t1
INNER JOIN table2 t2 ON t2.useridfromtable=t1.id
INNER JOIN table3 t3 ON t3.number = t2.number

新问题？

您有机会知道如何在结果上打印调用总和吗？在所有这些加入之后，我得到了同一用户的大约 10 条线路以及他们各自基于电话的呼叫，我所询问的内容是正确的，现在我需要返回 1 行中的所有呼叫，其值如下：

sum | user ID | user Name

原文

Question:

Table 1: id.1 | name.Joe | etc.Some | ...Other | ...Data
Table 2: id.X | number.+1 123 555 9999 | useridfromtable1.1 -> Linking telefone with Joe
Table 3: id. X | number.+1 123 555 9999 | calls.55

I need a query that join the 3 tables and I only have the id (userid) from the table 1.
So, I need from userid -> grab the telephone -> from the telefone grab calls on table3.

Answer:

SELECT t1.name,t1.id,t2.number,t3.calls
  FROM table1 t1
INNER JOIN table2 t2 ON t2.useridfromtable=t1.id
INNER JOIN table3 t3 ON t3.number = t2.number

New Question?

Any chance you know how can I print the sum of calls on the result? after all these join I get about 10 lines of the same user and their respective calls based on the phone, what is correct for what I asked, now I need return all the calls in 1 line with the values:

sum | user ID | user Name

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

假面具 2024-12-09 17:35:40

也许这会有用：

SELECT SUM(t3.calls) FROM table1 t1 INNER JOIN table2 t2 ON t2.useridfromtable=t1.id INNER JOIN table3 t3 ON t3.number = t2.number

Maybe this will be useful:

SELECT SUM(t3.calls) FROM table1 t1 INNER JOIN table2 t2 ON t2.useridfromtable=t1.id INNER JOIN table3 t3 ON t3.number = t2.number

回复收藏 0 原文

末骤雨初歇 2024-12-09 17:35:40

尝试这个查询：

SELECT sum(t3.calls), t1.id, t1.name
FROM table1 t1
INNER JOIN table2 t2 ON t2.useridfromtable=t1.id
INNER JOIN table3 t3 ON t3.number = t2.number
GROUP BY t1.id

Try this query:

SELECT sum(t3.calls), t1.id, t1.name
FROM table1 t1
INNER JOIN table2 t2 ON t2.useridfromtable=t1.id
INNER JOIN table3 t3 ON t3.number = t2.number
GROUP BY t1.id

回复收藏 0 原文

~没有更多了~