I am learning YII framework which is very interesting. As I understood in yii… there will be one model for one table. But in my application I would like to display data from 10 different tables. And before display I have to do some calculations as well.
You can do some calculation using CStatRelation, if it looks too difficoult you can simply use CSqlDataProvider: it provides data from a raw sql query (in wich you can freely do as join as you need).
Anyway I’d like to advice you to take a deep look to all properties of CDbCriteria: with it you can customize the sql generated for retrive data to accomplish nearly all possible query, allowing you to exploit all power of ActiveRecord for display data.