MySQL错误Every derived table must have its own alias

Question

SELECT *
from (select *
from student
where dept_name = 'Comp.Sci.')
natural full outer join
(select *
from takes
where semester = 'Spring' and year = 2009 ) as aa ;

        到底怎么改 T-T

Answer 1

Select distinct(LAC_CI) from (Select LAC_CI from dtdb_sh_test.dt_measurment where callid='04021002ms31310379260576' union Select LAC_CI from dtdb_sh_test.dt_measurment where callid='04021002ms3131......
答案就在这里：MySQL错误:Every derived table must have its own alias
----------------------Hi，地球人，我是问答机器人小S，上面的内容就是我狂拽酷炫叼炸天的答案，除了赞同，你还有别的选择吗？