I can not understand how to do a LEFT JOIN
using QueryBuilder
of symfony2, the query I need to ask is this:
SELECT * FROM extranet.version_portal v
LEFT JOIN extranet.version_portal_usuario vu
ON vu.version_id = v.id;
I can not understand how to do a LEFT JOIN
using QueryBuilder
of symfony2, the query I need to ask is this:
SELECT * FROM extranet.version_portal v
LEFT JOIN extranet.version_portal_usuario vu
ON vu.version_id = v.id;
According to the official découpage:
$qb->select(array('v'))
->from('version_portal', 'v')
$qb->leftJoin('u.version_id', 'vu', 'WITH', 'vu.id =
v.id')