mysql> select name,family from member as d
where mov in(select d.mov from d);
.
ERROR 1146 (42S02): Table 'film.d' doesn't exist
mysql> select name,family from member as d
where mov in(select d.mov from d);
.
ERROR 1146 (42S02): Table 'film.d' doesn't exist
d
in your subquery(select d.mov from d)
is not a valid table name. Are you trying to do some kind of correlated query with the member table by using the alias d here?