zend_db_select使用3个或更多表连接
所以Zend_db_select有方法
`joinUsing(table, join, [columns]) and joinInnerUsing(table, join, [columns])`
`joinLeftUsing(table, join, [columns])`
`joinRightUsing(table, join, [columns])`
`joinFullUsing(table, join, [columns])`
SELECT * FROM (j LEFT JOIN e ON j.id = e.eee) LEFT JOIN w ON w.www = e.id
没有找到相关结果
已邀请:
2 个回复
联课
$dbmodel->select(false) ->setIntegrityCheck(false) ->from(array('t1' => 'table1')) ->joinLeft(array('t2' => 'table2'), 't1.somefeild = t2.somefeild') ->joinLeft(array('t3' => 'table3'), 't2.somefeild = t3.somefeild')查询查询帆攀缺锯欧