- 论坛徽章:
- 0
|
create table t1
as
select movie_name,people_fullname movie_leadactor_name ,movie_director
from movie,people
where movie_leadactor=people_id;
select movie_name,people_fullname,movie_leadactor_name,people_fullname movie_director_name
from t1,people
where movie_director=people_id
合在一起写就是如下
select movie_name,people_fullname,movie_leadactor_name,people_fullname movie_director_name
from t1,people
(
select movie_name,people_fullname movie_leadactor_name ,movie_director
from movie,people
where movie_leadactor=people_id
)t1
where movie_director=people_id
[ 本帖最后由 talen-t 于 2006-7-31 15:33 编辑 ] |
|