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

回答編集履歴

1

コード追記

2020/11/26 14:40

投稿

hatena19
hatena19

スコア34367

answer CHANGED
@@ -9,4 +9,16 @@
9
9
  table1 INNER JOIN table2 ON table1.id = table2.id
10
10
  GROUP BY
11
11
  table1.id;
12
+ ```
13
+
14
+ クロス集計クエリを使うなら、
15
+ ```sql
16
+ TRANSFORM Sum(table1.score)
17
+ SELECT
18
+ table1.id
19
+ FROM
20
+ table1 INNER JOIN table2 ON table1.id = table2.id
21
+ GROUP BY table1.id
22
+ PIVOT
23
+ IIf([time] Between [start] And [goal],"OK_score","NO_score") In ("OK_score","NO_score");
12
24
  ```