search

Home >Database >Mysql Tutorial >mysql-MySQL错误Every derived table must have its own alias

mysql-MySQL错误Every derived table must have its own alias

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-06 09:39:40984browse

mysql

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 ;

<code>        到底怎么改 T-T</code>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-sql 语句的查询优化，各位看看可以怎么优化，新人初学，SQL有点复杂，压力山大。。。。。Next article：jsp查询mysql,表名是变量,需要前段输入，怎么实现

Related articles

See more