可以用的连接查询和md的内连接查询sql语句

getDirections
===

select  course.id as directionId,course.grade,course.name as courseName,
        course.submit_time as submitTime,course.status,
        project.name as projectName,
        direction.name as directionName,
        auditing.created
from ((course inner join project on course.project_id = project.id) inner join direction on course.direction_id = direction.id)
	inner join auditing on course.id = auditing.audited_id and auditing.type_id in (select id from auditing_type where auditing_type.name = "企业方案")
where course.project_id in 
(select project_id from course where course.enterprise_id = #{enterpriseId} and course.direction_id = #{directionId})