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)";
相關文章
- MySQL LEFT JOIN/ INNER JOIN/RIGHT JOINMySql
- sql中的join、left join、right joinSQL
- Yii學習系列之yii大致結構
- Yii2-application用法 (Yii::$app用法)APP
- Yii框架文摘之二yii的入口與app應用例項(Yii::app())框架APP
- Mysql join 的本質,Nested Loop Join 和 Hash JoinMySqlOOP
- mysql left join轉inner joinMySql
- sql之left join、right join、inner join的區別SQL
- 連線查詢簡析 join 、 left join 、 right join
- hash join\nest loop join\sort merge join的實驗OOP
- ZT:簡單介紹join,outer-join,semi-join,anti-join的區別
- yii學習
- LEFT JOIN 和JOIN 多表連線
- HASH JOIN ,MERGE JOIN ,NESTED LOOPOOP
- SQL中聯表查詢操作(LEFT JOIN, RIGHT JOIN, INNER JOIN)SQL
- 【yii】yii之元件詳解-載入邏輯薦元件
- 數倉工具—Hive語法之map join、reduce join、smb join(8)Hive
- sql的left join 、right join 、inner join之間的區別SQL
- nested loop,sort merge join,hash joinOOP
- JavaScript join()JavaScript
- FILTER JOINFilter
- SQL joinSQL
- hadoop 多表join:Map side join及Reduce side join範例HadoopIDE
- left join,right join,inner join的條件on和where的區別
- yii2 坑
- Yii2 事件事件
- yii 佇列不行佇列
- yii2 模型模型
- yii2-sessionSession
- yii2-CookieCookie
- HINT no_swap_join_inputs/swap_join_inputs
- sql left join 和 right join解釋SQL
- Inner Join, Left Outer Join和Association的區別
- HASH JOIN ,MERGE JOIN ,NESTED LOOP(R2)OOP
- HASH JOIN ,MERGE JOIN ,NESTED LOOP的比較OOP
- Fork/Join 框架框架
- mysql + left joinMySql
- Thread jointhread