Not In Condition In $Criteria

How to use NOT IN in $criteria as i m trying to get result which is not in other table in search: like

incidents and statements

so in incidents in am trying to search all the statments which are not in statements table. the reverse is true using inner join but this is Not working… I have used select for it but it is not working with other filters!!!

Thanks

Would addNotInCondition() help you?

http://www.yiiframework.com/doc/api/1.1/CDbCriteria#addNotInCondition-detail

thanks Maurizio Domba , A bit slow but works