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
Comments
Post a Comment