sql – Zend如何创建左连接

如何打开此左连接查询：

select advertisercontest.*,advertiseraccount.advertiserid,advertiseraccount.companyname
from advertisercontest
left join advertiseraccount on advertiseraccount.loginid = advertisercontest.loginid 
where advertisercontest.golive is not NULL;

进入Zend的左连接？

解决方法

$db = Zend_Db_Table::getDefaultAdapter();

    $select = $db->select();
    $select->from('advertisercontest','*')
            ->joinLeft(
                    'advertiseraccount','advertiseraccount.loginid = advertisercontest.loginid',array('advertiseraccount.advertiserid','advertiseraccount.companyname')
                    )
            ->where('advertisercontest.golive is not NULL');;

    $result = $db->fetchAll($select);

    var_dump($result);

希望没关系.

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!