mysql - How to solve mysql nested query?

Question

This is my query and output. Now i try to count total sum of unique item_id and name with this

SELECT name, SUM(item_id) 
FROM (SELECT *
      FROM items U
      JOIN users_items UI ON UI.item_id = U.id)

but it shows error

标签： mysqlsql

Answer 1

Do you find something below

 select name, sum(item_id) FROM items U
 JOIN users_items UI ON UI.item_id = U.id
 group  by name