質問編集履歴

質問修正

2015/06/07 10:10

投稿

スコア1161

test CHANGED Viewed

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

test 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;