I have a problem with my CDBCriteria. Here is an example:
$criteria = new CDbCriteria;
$criteria->select = 't.f_site_id, contentcontracts.f_content_contract_id as test';
$criteria->with = 'contentcontracts';
My select works fine on the first table and the query do the job. But when i look the query sent to my database, on foreign table all fields still selected:
And if there is no clause in my select about the foreign table, it is the same. How can I do a select on my second table?