https://wiki.ztm0929.cn/index.php?action=history&feed=atom&title=%E4%B8%89%E8%A1%A8%E8%BF%9E%E6%8E%A5
三表连接 - 版本历史
2026-04-30T22:06:54Z
本wiki上该页面的版本历史
MediaWiki 1.44.0
https://wiki.ztm0929.cn/index.php?title=%E4%B8%89%E8%A1%A8%E8%BF%9E%E6%8E%A5&diff=481&oldid=prev
天明：创建页面，内容为“学习MySQL如何三个表进行连接，理解内连接和左右连接的区别，实现方式如下：<syntaxhighlight lang="sql" line="1"> SELECT p.case_id, p.action_user_name, p.node_name, p.receive_time, p.action_time, p.action_type, p.action_detail, p.description_international, c.subject, o.content FROM bpm_process_log p JOIN bpm_case c ON p.case_id = c.id LEFT…”
2025-01-10T14:55:05Z
<p>创建页面，内容为“学习MySQL如何三个表进行连接，理解内连接和左右连接的区别，实现方式如下：<syntaxhighlight lang="sql" line="1"> SELECT p.case_id, p.action_user_name, p.node_name, p.receive_time, p.action_time, p.action_type, p.action_detail, p.description_international, c.subject, o.content FROM bpm_process_log p JOIN bpm_case c ON p.case_id = c.id LEFT…”</p>
<p><b>新页面</b></p><div>学习MySQL如何三个表进行连接，理解内连接和左右连接的区别，实现方式如下：<syntaxhighlight lang="sql" line="1"><br />
SELECT<br />
<br />
p.case_id,<br />
<br />
p.action_user_name,<br />
<br />
p.node_name,<br />
<br />
p.receive_time,<br />
<br />
p.action_time,<br />
<br />
p.action_type,<br />
<br />
p.action_detail,<br />
<br />
p.description_international,<br />
<br />
c.subject,<br />
<br />
o.content<br />
<br />
FROM<br />
<br />
bpm_process_log p<br />
<br />
JOIN<br />
<br />
bpm_case c<br />
<br />
ON<br />
<br />
p.case_id = c.id<br />
<br />
LEFT JOIN<br />
<br />
opinion o<br />
<br />
ON p.case_id = o.object_id<br />
<br />
WHERE<br />
<br />
c.template_id = 2009996271707753870<br />
<br />
AND p.receive_time > '2024-1-1 00:00:00'<br />
<br />
AND p.receive_time < '2025-1-1 00:00:00'<br />
</syntaxhighlight></div>
天明