跳至 [1] [全屏预览] -- select-- edu_trxorder.id 'id',-- edu_trxorder.student_name 'stu_name',-- edu_trxorder.mobile 'stu_mob',-- edu_course.subject_major_str 'nianji',-- user_expand.realname 'tea_name',-- user_user.mobile 'tea_mob',-- edu_course.join_num 'bm_num',-- edu_trxorder.lession_num 'keshi',-- edu_trxorder.course_name 'kecheng',-- edu_course.course_plan 'kaike_time',-- edu_trxorder.pay_time 'tijiao_time'-- from-- edu_trxorder-- inner join edu_course on edu_trxorder.course_id = edu_course.id-- inner join edu_teacher on edu_trxorder.teacher_id = edu_teacher.id-- inner join user_user on user_user.id = edu_teacher.user_id-- inner join user_expand on user_expand.user_id = user_user.id-- -- select edu_trxorder.id 'id', edu_trxorder.student_name 'stu_name', t.realname, edu_trxorder.mobile 'stu_mob', edu_course.subject_major_str 'nianji', edu_course.start_time 's_time', edu_course.end_time 'e_time', edu_trxorder.create_time 'c_time', user_expand.realname 'tea_name', user_user.mobile 'tea_mob', edu_trxorder.amount 'amount', edu_trxorder.pay_type 'pay_type', edu_trxorder.trx_status 'trx_status', edu_course.join_num 'bm_num', edu_trxorder.lession_num 'keshi', edu_trxorder.course_name 'kecheng', edu_course.course_plan 'kaike_time', edu_trxorder.pay_time 'tijiao_time'from edu_trxorder, ( select edu_trxorder.id as tid, realname from edu_trxorder left join edu_code_order on edu_code_order.order_id = edu_trxorder.request_id left join edu_user_promo on edu_user_promo.promo_code = edu_code_order.code left join user_user on user_user.id = edu_user_promo.user_id left join user_expand on user_user.id = user_expand.user_id ) t, edu_course, edu_teacher, user_user, user_expandwhere edu_trxorder.course_id = edu_course.idand edu_trxorder.teacher_id = edu_teacher.idand user_user.id = edu_teacher.user_idand user_expand.user_id = user_user.idand t.tid = edu_trxorder.idand t.realname is not null