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.