質問編集履歴

質問修正

2015/06/07 10:10

投稿

スコア1161

title CHANGED Viewed

	@@ -1,1 +1,1 @@
1	- derived〜のエラーが出る
1	+ ERROR 1248 (42000): Every derived table must have its own aliasのエラーが出る

body CHANGED Viewed

@@ -1,4 +1,4 @@
-select scores.id,name,score,deviation from (select score,deviation from scores where score >30) union all(select score,deviation from scores left join students on scores.id = students.id where name like %suzuki%) as uni;
+select scores.id,score,deviation from (select score,deviation from scores where score >30) union all(select score,deviation from scores left join students on scores.id = students.id where name like %suzuki%) as uni;
 このクエリを実行すると、ERROR 1248 (42000): Every derived table must have its own aliasとなります。