日期:2014-05-17 浏览次数:20584 次
select * from
(
select * from tb_lesson tbl where tbl.sectionID=1
) a
inner join tb_lessonGrade tblg
on a.lessonID = tblg.lessonID
SELECT DISTINCT grade
FROM tb_lessonGrade
WHERE lessonID IN(
SELECT DISTINCT lessonID
FROM tb_lesson
WHERE sectionID=1
)
select grade from tb_lessonGrade where lessonID in (select DISTINCT le.lessonID from tb_lesson le where sectionID=1)