PHP / MYSQL语句因此选择Max Sum of Join

Question

I have Problems with a select statement, as a little help here are the important columns:

---

Table1            
ID NAME           

TABLE 2  
ID U_ID COUNTER

---

The ID of Table 1 Matches the U_ID of Table 2. Table 2 contains many entries for the same u_id.

What I want to do is to get the Name of the "user" (table 1) who has in sum the max. counter.

What I got since now is the join of the tables (Where clause depends on other rows which are not important for the problem).

Can anyone help me on this issue?

Answer 1

SELECT name,
      SUM(counter) as counter
FROM table1
JOIN table2
ON table1.id = table2.u_id
GROUP BY u_id
ORDER BY counter DESC 
LIMIT 1