是否可以在Yii的ActiveRecord中进行子查询?
Is it possible to make sub-queries in ActiveRecord in Yii?
我有这样的查询:
select * from table1 where table1.field1 in (select table2.field2 from table2)
select * from table1 where table1.field1 in (select table2.field2 from table2)
我当前正在使用休闲代码:
i'm currently using the fallowing code:
object1::model()->findAll(array('condition'=>'t.field1 in (select table2.field2 from table2)'))
我想知道是否有一种方法可以在不使用SQL且不使用联接的情况下构造子查询.
i would like to know if there is a manner to construct the sub-query without using SQL, and without using joins.
有什么解决办法吗?
在此先感谢
推荐答案首先通过db字段查找doublet:
First find doublets by db fields:
$model=new MyModel('search'); $model->unsetAttributes(); $criteria=new CDbCriteria(); $criteria->select='col1,col2,col3'; $criteria->group = 'col1,col2,col3'; $criteria->having = 'COUNT(col1) > 1 AND COUNT(col2) > 1 AND COUNT(col3) > 1';获取子查询:
$subQuery=$model->getCommandBuilder()->createFindCommand($model->getTableSchema(),$criteria)->getText();添加子查询条件:
$mainCriteria=new CDbCriteria(); $mainCriteria->condition=' (col1,col2,col3) in ('.$subQuery.') '; $mainCriteria->order = 'col1,col2,col3';使用方法:
$result = MyModel::model()->findAll($mainCriteria);或者:
$dataProvider = new CActiveDataProvider('MyModel', array( 'criteria'=>$mainCriteria, ));来源: www.yiiframework/wiki/364/using-sub-query-for-doubletts/
更多推荐
子查询ActiveRecord Yii
发布评论