Custom Query

Hi.

I want to create a query like this:

SELECT d.cod_cli, d.name_cli, d.cod_cia (SELECT name_cia FROM cia c WHERE c.cod_cia=d.cod_cia) AS name_cia

FROM client d

I’m beginning my journey with Yii and don’t know how to figure out this simple query.

Can anybody help me?

Thanks.




$sql = "SELECT d.cod_cli, d.name_cli, d.cod_cia (SELECT name_cia FROM cia c WHERE c.cod_cia=d.cod_cia) AS name_cia

FROM client d";

Yii::$app->db->createCommand($sql)->queryAll();



1 Like