如何组合dql查询

Question

我有两个DQL查询

$dql = "SELECT i FROM Edufaction\Bundle\EdufactionBundle\Entity\Institute i JOIN i.instsummary s where s.instaffiliation IN ($affiliation1)";

$dql = "SELECT i FROM Edufaction\Bundle\EdufactionBundle\Entity\Institute i where i.institutefeerange IN ($feerange)";

如何将这两个查询合并为单个查询？

Answer 1

您可以尝试使用AND运算符执行以下操作

$dql = "SELECT i FROM Edufaction\Bundle\EdufactionBundle\Entity\Institute i JOIN i.instsummary s where s.instaffiliation IN ($affiliation1) AND  i.institutefeerange IN ($feerange)";