我想在CakePHP中编写以下内容:
(select email
from membersdatabase
where memberid not in
(select memberid from deregisteredmembers)
在membersdatabase模型中,编写以下查询:
$options = array(
'conditions' => array('deregisteredmembers.memberid is null'),
'joins' => array(
array(
'alias' => 'deregisteredmembers',
'table' => 'deregisteredmembers',
'type' => 'LEFT',
'conditions' => array(
'deregisteredmembers.memberid = membersdatabase.id',
),
)
),
'fields' => array('membersdatabase.email')
);
$this->find('all',$options);
您会得到理想的结果
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句