symfony subquery

doctrine query builder Подзапрос (subquery) "SELECT * WHERE value IN (SELECT ...)"

Submitted by melisa on Tue, 04/30/2019 - 18:25

SELECT column-names
FROM table-name1
WHERE value IN (SELECT column-name
       FROM table-name2 
        WHERE condition)

Такой подзапрос можно оформить с помощью QueryBuilder-а через expr()->in(). Например, так: