I had been searching this past week about relations that has many and how to query it in mysql using yii and i can’t find that works. can somebody help me in showing how to use mysql query for has_many relations. thanks 
I had been searching this past week about relations that has many and how to query it in mysql using yii and i can’t find that works. can somebody help me in showing how to use mysql query for has_many relations. thanks
here is an example that should get you started http://www.yiiframework.com/forum/index.php?/topic/10925-has-many-relation-and-delete/page__p__53692#entry53692
also a good wiki: http://www.yiiframework.com/wiki/281/searching-and-sorting-by-related-model-in-cgridview
in the comments you found the way to do it with HAS_MANY relations. 