Join Query

[rupsg (Ibdcwebmaster)]

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

[dsuilar]

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

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