how come when I use
$criteria->with = 'basicData' and the model BasicData is in another database, that the CActiveDataProvider doesn't work?
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PersonnelTracker.BasicData' doesn't exist. The SQL statement executed was: SELECT COUNT(DISTINCT `t`.`id`) FROM `Vehicle` `t` LEFT OUTER JOIN `BasicData` `basicData` ON (`t`.`assignedToEmployee`=`basicData`.`id`)
It should be ‘LEFT OUTER JOIN People.BasicData’.
I would expect Yii to find that out based on the database connection of the model.
Can somebody help me please?