mysql - every derived table must have its own alias -

i running query on mysql

select id (     select id, msisdn     (         select * tt2     ) ); 

and giving error:

every derived table must have own alias.

what wrong ?

every derived table (aka sub-query) must indeed have alias. i.e. each query in brackets must given alias (as whatever), can used refer in rest of outer query.

select id (     select id, msisdn (         select * tt2     ) t ) t 

in case, of course, entire query replaced with:

select id tt2