teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

訂正

2021/03/31 04:53

投稿

sazi
sazi

スコア25430

answer CHANGED
@@ -4,5 +4,5 @@
4
4
  SELECT I.items_name, SUM(C.count)
5
5
  FROM my_items AS I, carts AS C
6
6
  WHERE I.id=C.item_id
7
- GROUP BY C.item_id
7
+ GROUP BY C.item_id, I.items_name
8
8
  ```