select A.*,B.*,C.* from IXTERMINAL A,MOVIE_PLAYHIS_INFO B,MOVIE_INFO C where ----三个表关联 order by A.TML_ID 改显示名称,,不知道是否这样?
SELECT COUNT(MPI.MOVIE_PLAYHIS_ID),MPI.TML_ID,MPI.MOVIE_ID,MPI.START_TIME,MPI.END_TIME, MI.VIDEO_FORMAT,MI.VIDEO_LENGTH,MI.AUDIO_LENGTH,MI.MOVIE_TIME_LENGTH, TML.CINEMA_ID,TML.GROUP_ID FROM MOVIE_PLAYHIS_INFO MPI,MOVIE_INFO MI,IXTERMINAL TML WHERE MPI.MOVIE_ID = MI.MOVIE_ID AND MPI.TML_ID = TML.TML_ID GROUP BY MPI.MOVIE_ID想要以上的效果 ,上面SQL语句有问题
这个貌似比较基础啊...
where ----三个表关联
order by A.TML_ID
改显示名称,,不知道是否这样?
MI.VIDEO_FORMAT,MI.VIDEO_LENGTH,MI.AUDIO_LENGTH,MI.MOVIE_TIME_LENGTH,
TML.CINEMA_ID,TML.GROUP_ID
FROM MOVIE_PLAYHIS_INFO MPI,MOVIE_INFO MI,IXTERMINAL TML
WHERE MPI.MOVIE_ID = MI.MOVIE_ID
AND MPI.TML_ID = TML.TML_ID
GROUP BY MPI.MOVIE_ID想要以上的效果 ,上面SQL语句有问题