Zend Framework: Zend_Db_Select - how to join custom subquery table?

Question

$select->joinRight(array('i' => '(SELECT * FROM images ORDER BY image_id)'),'i.ad_id = '. $main .'.id',$imarray);

Like that doesn't work. Subquery getting inside quotes.

Like that:

RIGHT JOIN `(SELECT * FROM images ORDER BY image_id)` AS `i` ON i.ad_id = a.id

Thanks ;)

Tomáš Fejfar · Accepted Answer · 2011-04-26 15:12:32Z

11

Use

$select->joinRight(
    array('i' => new Zend_Db_Expr('(SELECT * FROM images ORDER BY image_id)')),
    'i.ad_id = '. $main .'.id',
    $imarray
);

answered Apr 26, 2011 at 15:12

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tomáš Fejfar Over a year ago

I thought that, but I was in good mood. That why it's not RTFM :D

Tomáš Fejfar Over a year ago

BTW: I think that if you replaced the string with Zend_Db_Select object it would work as well....

mindlock · Accepted Answer · 2012-07-12 07:31:20Z

5

I feel This is easier to read and navigate...

      $sub = $this->select()
            ->setIntegrityCheck(false)
            ->from(array('i' => 'images'), array('*'))
            ->order('i.image_id');

$select = $this->select()
             ->setIntegrityCheck(false)
             ->from(array('m' => 'MAIN_TABLE'), array('*'))
             ->joinRight(array('i' => $sub), 'i.ad_id = m.id', array('*'));

   return $this->select($select);

answered Jul 12, 2012 at 7:31

mindlock

511 silver badge2 bronze badges

Collectives™ on Stack Overflow

Zend Framework: Zend_Db_Select - how to join custom subquery table?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related