Hello,
Can you help me to build this query using Query Builder ? I don't get it :/
$phql = 'SELECT t1.id
FROM Apps\Common\Models\Table1 t1 inner join Apps\Common\Models\Table2 t2 ON (t1.id_t2 = t2.id)
inner join Apps\Common\Models\Table3 t3 ON (t3.id_t2 = t2.id)
WHERE t1.col1 = :col1: AND t3.col2 = :col2:';
$query = $this->modelsManager->createQuery($phql);
$object = $query->getSingleResult(['col1' => $data->col1, 'col2' => $data->col2]);
Thanks