Can't get correct amount of data when using CDbCriteria

Hello. I’m trying to join two tables. I’m using the following code:

$jobCriteria = new CDbCriteria;
    $jobCriteria->join = 'JOIN customer ON = customer_client_id';
    $jobCriteria->select = ', lang_id, customer_client_id, title, last_search_day,, status,';
    $jobCriteria->addInCondition('customer_client_id', $customer_ids);
    $jobCriteria->addCondition('status = 11');
    $result = Job::model()->findAll($jobCriteria);

But I’m only getting data from the job table and no data from the customer table. I’ve tried the SQL statement in phpMyAdmin, and it works there. Anyone seeing what’s wrong here? Thanks in advance!

In order to get this data you need relational queries: Working with Databases: Relational Active Record | The Definitive Guide to Yii 1.1 | Yii PHP Framework

Thank you so much for the reply, @samdark .