findall with join two tables

Yii 1.1 General Discussion
1

I have a query like this




"SELECT t1.id ,t1.status,t1.patient_lastname,t1.patient_firstname FROM patients AS t1 JOIN episode AS t2 WHERE t2.id = t1.id AND t2.status='C'"

How i write this using findall ??

I have two models Patients(of table patients) and Episode(of table episode)

2

Did you configure the relations between these classes? You can read about it in the guide. Also I think you should use “ON t2.id = t1.id” instead of “WHERE”. “JOIN” without the “ON” part doesn’t make much sense.

3

thank u… i wil try and get back to you…