有关一条SQL语句的问题？

Question

两个查询，如何将其合并到一起SELECT C.*,D.CINEMA_ID,D.GROUP_ID,D.TML_ID 
FROM 
(SELECT A.*,B.* 
FROM 
(SELECT START_TIME,END_TIME,MOVIE_PLAYHIS_ID,MOVIE_ID MPI_MOVIE_ID ,TML_ID MPI_TML_ID 
FROM 
MOVIE_PLAYHIS_INFO) A,MOVIE_INFO B 
WHERE A.MPI_MOVIE_ID = B.MOVIE_ID) C,IXTERMINAL D 
WHERE C.MPI_TML_ID = D.TML_ID///////////////////////////////////////////////////////////////////////////////////////////////////////
SELECT COUNT(E.MOVIE_PLAYHIS_ID) PLAY_COUNT
FROM 
(SELECT C.*,D.CINEMA_ID,D.GROUP_ID,D.TML_ID 
FROM 
(SELECT A.*,B.* 
FROM 
(SELECT START_TIME,END_TIME,MOVIE_PLAYHIS_ID,MOVIE_ID MPI_MOVIE_ID ,TML_ID MPI_TML_ID 
FROM 
MOVIE_PLAYHIS_INFO) A,MOVIE_INFO B 
WHERE A.MPI_MOVIE_ID = B.MOVIE_ID) C,IXTERMINAL D 
WHERE C.MPI_TML_ID = D.TML_ID) E 
GROUP BY E.MOVIE_ID

Answer 1

将第一个查询的列和第二个查询的列进行组合一下，并集   关联字段为MOVIE_PLAYHIS_ID

Answer 2

IXTERMINAL(终端表)[TML_ID] ,CINEMA_ID,GROUP_ID
MOVIE_PLAYHIS_INFO(播放历史表)MOVIE_PLAYHIS_ID,[MOVIE_ID],[TML_ID]
MOVIE_INFO(电影表)[MOVIE_ID],MOVIE_NAME,VIDEO_FORMAT,MOVIE_TIME_LENGTHIXTERMINAL.TML_ID = MOVIE_PLAYHIS_INFO.TML_ID   1:N
MOVIE_INFO.MOVIE_ID = MOVIE_PLAYHIS_INFO.MOVIE_ID 1:N

Answer 3

查询这三个表 增加统计列（COUNT(MOVIE_PLAYHIS_ID)）按 MOVIE_ID分组