Doctrine2中的JOIN ON和JOIN WITH有什么区别? [英] What is the difference between JOIN ON and JOIN WITH in Doctrine2?
本文介绍了Doctrine2中的JOIN ON和JOIN WITH有什么区别?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
Doctrine2中的JOIN ON和JOIN WITH有什么区别?
What is the difference between JOIN ON and JOIN WITH in Doctrine2?
我在手册中找不到任何相关信息.
I couldn't find any relevant info in the manual.
推荐答案
ON替换了原始连接条件，
WITH为其添加条件.
ON replaces the original join condition,
WITH adds a condition to it.
示例:
[Album] ---OneToMany---> [Track]
-
第一种情况
Case One
DQL
FROM Album a LEFT JOIN a.Track t WITH t.status = 1
将翻译成SQL
FROM Album a LEFT JOIN Track t ON t.album_id = a.id AND t.status = 1
第二种情况
Case Two
DQL
FROM Album a LEFT JOIN a.Track t ON t.status = 1
将翻译成SQL
FROM Album a LEFT JOIN Track t ON t.status = 1
这篇关于Doctrine2中的JOIN ON和JOIN WITH有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
