/** * Query using outer on automatic join * @return <type> */ public function criteriaCommand14() { $setor = new Setor(); $criteria = $setor->getCriteria("select nome, count(usuarios.idUsuario) " . "where login like 'A%' " . "group by nome " . "having count(usuarios.idUsuario) = 0")->setAssociationType('usuarios', 'left'); return $criteria; }