mysql联合排序_mysql多个表联合排序

#课程分类表

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`course_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '课程类型(1.语文;2.数学;)',

`lesson_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '课堂类型(0.一对一试听课;1.一对一小班课;2.一对一大班课;3.一对多小班课;4.一对多大班课;5.一对多小班试听课)',

`name` varchar(64) NOT NULL DEFAULT '' COMMENT '课程名',

`level_num` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '该课程下总级别数量',

`unit_num` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '该Level下总unit数',

`lesson_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '该level下总lesson数',

`lesson_class_hour` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '该Level下所有Lesson总学时(分钟)',

`class_hour` int(8) DEFAULT '25' COMMENT '当前课程每节课的上课时长',

`lesson_before_time` int(8) DEFAULT '5' COMMENT '课前备课时间(分钟)',

`lesson_after_time` int(8) DEFAULT '5' COMMENT '课后休息时间(分钟)',

`lesson_interval_time` int(8) DEFAULT '15' COMMENT '课程间隔时间(分钟)',

`sort`