Yii Framework Forum: Join Query - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Join Query yii2 Join Query

#1 User is offline   ibdcwebmaster@gmail.com 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 6
  • Joined: 24-July 14

Posted 25 March 2016 - 03:28 AM

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
0

#2 User is offline   dsuilar 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 20-April 14

Posted 29 April 2016 - 08:10 AM

View Postibdcwebmaster@gmail.com, on 25 March 2016 - 03:28 AM, said:

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.yiiframew...-yii-framework/
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users