combining results of two select objects Zend\Db\sql\sql

Question

I know the way to combine two select statments would look like this:

 SELECT tableA.Id
 FROM tableB 
 INNER JOIN tableA ON [tableB].Id = tableA.Owner

 UNION

 SELECT tableA.Id, tableA.Name
 FROM [tableC] 
 RIGHT OUTER JOIN tableA ON [tableC].tableAId =  tableA.Id

But how would it be if I'm using sql object?

   $sql = new Sql($adapter);
   $select = $sql->select();
   $select ->from(tableA);
   $select ->join(...)

Any help would be much appreciated. Thanks in advance

There's still no union available in Zend\Db\Sql\Select. Check this post. — lluisaznar
– lluisaznar, Commented Apr 29, 2014 at 5:06

Kunal Dethe · Accepted Answer · 2014-05-27 11:14:37Z

2

ZF2 does have combine that works as union -

$select1->combine($select2);

I hope its helps someone.

answered May 27, 2014 at 11:14

Kunal Dethe

1,2741 gold badge19 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

combining results of two select objects Zend\Db\sql\sql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related