SELECT b.id,b.title,b.description FROM memberships AS m JOIN blogs AS b ON b.id = m.blog_id WHERE m.user_id = ? ORDER BY m.created LIMIT 0,30
(此查询有效并返回结果)
成员资格是博客和用户之间的链接表.这很简单id | blog_id | user_id |事务.
这是我到目前为止所拥有的:
// $table = Zend_Db_Table instance,$id = a user id $select = $table->select() ->from(array('m' => 'memberships'),array('b.id','b.title','b.description')) ->join(array('b' => 'blogs'),'b.id = m.blog_id') ->where('m.user_id = ?',(int) $id) ->order('m.created DESC') ->limit(0,30);
这是我得到的(对我来说很奇怪)错误:
#0: Select query cannot join with another table
Occurred on line 211 of
D:\...\library\Zend\Db\Table\Select.PHP
.
谢谢你的帮助.