yii query builder in select statemnt having on condition

Yii 1.1 General Discussion
1

Hi all,

<code>SELECT us.sid, us.uid

FROM user_survey_entry us

JOIN survey_entry se ON ( se.status =1

AND se.sid = us.sid )

WHERE us.uid =60853

LIMIT 0 , 30

</code>

plz help me with the query… how to give this query in yii without using CDbcriteria

Thanks.

2

Data Access Objects (DAO)