mysql error

1 Every derived table must have its own alias

多表查询时，要给查找结果添加一个名字，注意表名不要带引号，直接写

select a from(
SELECT a ,b as 'lieming' FROM biao
) as biaobiao where b='name';