MySql：Every derived table must have its own alias

Every derived table must have its own alias

在做多表關聯查詢，或者查詢的時候産生新的表的時候會出現這個錯誤：Every derived table must have its own alias

根本原因在于沒有指定别名。

示例：

select
	*
from 
	(
        select ID, NAME from B
	)
where ID='1';
           

上述SQL就會報錯：Every derived table must have its own alias，因為子查詢

select ID, NAME from B

沒有指定别名，如下修改後就沒有問題了

select
	A.*
from 
	(
        select ID, NAME from B
	) A
where A.ID='1';
           

謹記！