sql - Zend 如何创建左连接

Question

如何打开这个左连接查询:

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

在 Zend 中加入左连接？

Answer 1

你可以这样做:

    $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);

这是 Zend_Db_Select documentation .