yii framework join
$criteria->join="inner join (config as b,area as c,position as d,app as e,config_has_area as f,config_has_position as g,user as a ) ON (
a.Config_id=b.id
and b.id=f.Config_id
and b.id=g.Config_id
and f.Area_id=c.id
and g.Position_id=d.id
and a.Status=$status
and d.id=$position)";
相關文章
- join、inner join、left join、right join、outer join的區別
- MySQL LEFT JOIN/ INNER JOIN/RIGHT JOINMySql
- Mysql join 的本質,Nested Loop Join 和 Hash JoinMySqlOOP
- mysql left join轉inner joinMySql
- Yii2-application用法 (Yii::$app用法)APP
- .join()
- Yii 技巧
- LEFT JOIN 和JOIN 多表連線
- sql:left join和join區別SQL
- sql的left join 、right join 、inner join之間的區別SQL
- mysql中的left join、right join 、inner join的詳細用法MySql
- 數倉工具—Hive語法之map join、reduce join、smb join(8)Hive
- Yii 批次插入
- JavaScript join()JavaScript
- Thread jointhread
- Inner Join, Left Outer Join和Association的區別
- yii2 模型模型
- yii2-sessionSession
- yii2-CookieCookie
- Yii2 事件事件
- yii2 坑
- yii 佇列不行佇列
- mysql + left joinMySql
- Thread.jointhread
- Fork/Join框架框架
- Fork/Join 框架框架
- cmu15545筆記-Join演算法(Join Algorithms)筆記演算法Go
- mysql INNER JOIN、LEFT JOIN、RIGHT JOIN;內連線(等值連線)、左連線、右連線MySql
- Android FrameworkAndroidFramework
- Android Framework中的Application Framework層介紹AndroidFrameworkAPP
- Yii2 where使用
- yii2檢視
- yii2-分頁
- Yii2 Action用法
- yii2 總結
- Yii2使用Composer
- yii 安裝及配置
- YII安裝踩坑
- SQL not exist out joinSQL