如何在CDbCriteria（yii）中编写以下查询？

Question

$query="select U.MUID,U.UID,U.PWD,U.UNAME,U.EMAILID,U.GROUPID,U.TRANSDATE,U.ACTIVEYN,
            G.GRP_DESC,G.FACTORY_SETTING from mas_users U
            inner join user_group G on U.GROUPID=G.GROUPID
            where U.ACTIVEYN=1 and U.GROUPID  <> 6 AND MUID <>1729 and MUID <>1727 and U.GROUPID <> 100000 order by U.GROUPID";

Please help me to write the query as CDBcrieteria in yii

Answer 1

have a look at this

this

this is the best way of extarting data from table joins