合并两个选择对象 Zend\Db\sql\sql 的结果 [英] combining results of two select objects Zend\Db\sql\sql

问题描述

我知道组合两个选择语句的方法如下所示:

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

但是如果我使用 sql 对象会怎样?

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

推荐答案

ZF2 确实有 combine 作为联合工作 -

ZF2 does have combine that works as union -

$select1->combine($select2);

我希望它对某人有所帮助.

I hope its helps someone.

这篇关于合并两个选择对象 Zend\Db\sql\sql 的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！