Join Query

International Indian
1

Can anybody help me in generating yii2 query for following sql query

SELECT a.companyName,b.branchAdd,c.contactName,c.contactMailAdd from tbl_company as a INNER JOIN tbl_branch as b ON a.companyId= b.companyId

INNER JOIN tbl_contact as c ON b.branchId= c.branchId where contactMailAdd=‘Yes’

ORDER BY a.companyName

2

http://www.yiiframework.com/forum/index.php/topic/47668-join-query-in-yii-framework/