What is the difference between JOIN ON and JOIN WITH in Doctrine2?
ON replaces the original join condition,WITH adds a condition to it.
Example:
[Album] ---OneToMany---> [Track]Case One
DQL
FROM Album a LEFT JOIN a.Track t WITH t.status = 1Will translate in SQL
FROM Album a LEFT JOIN Track t ON t.album_id = a.id AND t.status = 1Case Two
DQL
FROM Album a LEFT JOIN a.Track t ON t.status = 1Will translate in SQL
FROM Album a LEFT JOIN Track t ON t.status = 1