作为群里的管理员,号召共同学习Mysql
?
?
这样不但可以自己学到东西,也可以大家一起学到东西! SQL也是需要学习的,很多东西大家都可以好好学习的
select * from video_onelesson where video_onelesson.video_id in ( select rentvideo_onelesson.video_id from rentvideo_onelesson where rentvideo_onelesson.member_id = ( select member_onelesson.member_id from member_onelesson where member_onelesson.name = '色色' ) ) ;select * from member_onelesson where member_onelesson.member_id in (select rentvideo_onelesson.member_id from rentvideo_onelesson where rentvideo_onelesson.video_id = (select video_onelesson.video_id from video_onelesson where video_onelesson.title = '色即是空1' )); 3 楼 vb2005xu 2009-03-03 http://www.iamsese.cn/view/sqlstudy/