How to make join?

Question

Yii

There is a table with projects f_data440, there is a field Counterparties - f8260, id from the table with counterparties f_data440 comes there, this table has id and names - f483. The question is, how to get from the table with projects not the id of counterparties, but their names? How to make join? I read the manuals, I understand the logic

Answer 1

To get the names of counterparties, you need to specify the name field in the select, join has nothing to do with it. And if this happens through the model, then you need to make the corresponding field in the project model, and specify it in the rules.