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

最新推荐文章于 2023-11-17 16:31:35 发布

-001

最新推荐文章于 2023-11-17 16:31:35 发布

阅读量421

点赞数

分类专栏：个人笔记后端 beetlsql

本文链接：https://blog.csdn.net/qq_36712111/article/details/87634184

版权

后端同时被 3 个专栏收录

20 篇文章 0 订阅

订阅专栏

个人笔记

18 篇文章 0 订阅

订阅专栏

beetlsql

5 篇文章 0 订阅

订阅专栏

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})