Select Columns to return when joining a table with Zend\Db\Sql

Question

I just want to return one column (per.cd_acao), so I tried something like:

$select->from(array('act' => 'tb_acao'))
           ->join(array('per' => 'tb_perfil_acao'),
                'per.cd_acao = act.cd_acao',
                array('cd_acao'),
                $select::JOIN_INNER
            );

but this is producing a query string like: SELECT "act".*, "per"."cd_acao" AS "cd_acao" FROM "tb_acao" AS "act" INNER JOIN "tb_perfil_acao" AS "per" ON "per"."cd_acao" = "act"."cd_acao" WHERE "per"."sq_perfil" = '89'

it is bringing all columns from the first table, when I want none. What am I missing here?

Update

summarizing: When I don't inform 'columns' in a select object, it defaults to return all columns to me. But when I'm joining, I don't want any columns to be returned by the first table.

XVirtusX · Accepted Answer · 2015-09-08 19:13:55Z

4

An empty array will suffice

$select->from(array('act' => 'tb_acao'))
           ->columns(array())
           ->join(array('per' => 'tb_perfil_acao'),
                'per.cd_acao = act.cd_acao',
                array('cd_acao'),
                $select::JOIN_INNER
            );

answered Sep 8, 2015 at 19:13

XVirtusX

7193 gold badges12 silver badges30 bronze badges

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

Comments

UWU_SANDUN · Accepted Answer · 2015-09-11 08:54:38Z

0

Try with this query

use Zend\Db\Sql\Sql;

protected $tableGateway;
public $adapter;

public function __construct(TableGateway $tableGateway)
{
    $this->tableGateway = $tableGateway;
}

publice function getData(){
    $adapter = $this->tableGateway->getAdapter();
    $sql = new Sql($adapter);
    $select = $sql->select();
    $select->from('tb_acao')
       ->join('per'),
            'per.cd_acao = act.cd_acao',
            array('cd_acao'),
        );
    $statement = $sql->prepareStatementForSqlObject($select);
    $results = $statement->execute();

    return $results;
}

answered Sep 11, 2015 at 8:54

UWU_SANDUN

1,22315 silver badges22 bronze badges

Collectives™ on Stack Overflow

Select Columns to return when joining a table with Zend\Db\Sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related