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

回答編集履歴

1

コード修正

2021/11/04 04:32

投稿

hatena19
hatena19

スコア34367

answer CHANGED
@@ -16,7 +16,7 @@
16
16
 
17
17
  F1でグループ化してF2で集計
18
18
  ```sql
19
- select Fa, Sum(F2) As F2_Sum
19
+ select F1, Sum(F2) As F2_Sum
20
20
  from table1
21
21
  group by F1;
22
22
  ```
@@ -56,7 +56,7 @@
56
56
 
57
57
  ```sql
58
58
  select F1, F2
59
- from table2 inner join table3 on table2 .FKey = table23.FKey;
59
+ from table2 inner join table3 on table2 .FKey = table3.FKey;
60
60
  ```
61
61
 
62
62
  | F1 |F2 |