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

回答編集履歴

1

修正

2021/02/17 11:30

投稿

Orlofsky
Orlofsky

スコア16419

answer CHANGED
@@ -1,9 +1,9 @@
1
1
  ```SQL
2
2
  SELECT
3
- fi.title
3
+ ca.name
4
- FROM film fi
4
+ FROM category ca
5
5
  INNER JOIN film_category fc
6
- ON fi.category_id = fc.category_id
6
+ ON ca.category_id = fc.category_id
7
7
  where
8
- fi.category_id = 1;
8
+ ca.category_id = 1;
9
9
  ```