Zend Db Table Three tables JOIN

Question

1. payment(user_id, calculation_id)
2. user(id, user_name)
3. calculation(id, period_start_date, period_end_date)

I need to select payments with user_name, period_start_date, period_end_date. How can I do it within one query in Zend Framework?

Thanks a lot.

Alex Pliutau · Accepted Answer · 2015-02-06 04:26:51Z

11

I have found the solution:

$db     = new Zend_Db_Table('payment');
$select = $db->select()->setIntegrityCheck(false);
$select->from('payment')
       ->join('user', 'user.id = payment.user_id', array('user_name'))
       ->join('calculation', 'calculation.id = payment.calculation_id', array('period_start_date', 'period_end_date'));

$payment = $db->fetchAll($select)->toArray();

edited Feb 6, 2015 at 4:26

answered Oct 14, 2010 at 9:24

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

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

Collectives™ on Stack Overflow

Zend Db Table Three tables JOIN

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related