How to sort by 3 table Yii 1.1?

Question

Yii

There are 3 tables, how can I sort according to data from 3 tables.
1table( id, name, etc) 2table(category) 3table(category, id, sorting)
Each category has its own sorting.

Answer 1

Your question can be answered - How is it possible.
on the topic, no links are described, or anything. And we left the prefix for reading thoughts at home

Answer 2

The question is like porridge. If you understand correctly, it should help you

new CDbcriteria([
'order' => 'relation_table.sort_field'
])