video 表:id 主键,videoclass 外键;
course表:id主键,coursename;
查询video表,video表中的外键信息也查询出来:
ps = conn.prepareStatement(" select b.*,a.coursename,a.* from video b, course a where b.videoclass=a.courseid ");
video 表:id 主键,videoclass 外键;
course表:id主键,coursename;
查询video表,video表中的外键信息也查询出来:
ps = conn.prepareStatement(" select b.*,a.coursename,a.* from video b, course a where b.videoclass=a.courseid ");