通常,您会执行以下操作:
$q = Doctrine_Query::create() ->from('User u') ->whereIn('u.id', array(1, 2, 3));但我认为这更适合您的需求:
$q = Doctrine_Query::create() ->from('Foo f') ->where('f.group_id IN (SELECt f.group_id FROM alert a WHERe a.monitor_id = ?)', 4);
通常,您会执行以下操作:
$q = Doctrine_Query::create() ->from('User u') ->whereIn('u.id', array(1, 2, 3));但我认为这更适合您的需求:
$q = Doctrine_Query::create() ->from('Foo f') ->where('f.group_id IN (SELECt f.group_id FROM alert a WHERe a.monitor_id = ?)', 4);