【MySQL】子查询必须加别名

即便外层查询没有用到，也必须给子查询起一个别名，否则无法执行，例如：

select
	*
from
	(
	select
		id,
		name
	from
		tt_order
	where
		po_id <= 60
);

报错：

Every derived table must have its own alias

更正：

select
	*
from
	(
	select
		id,
		name
	from
		tt_order
	where
		po_id <= 60
) a;

即：

select (select * from table) 别名;