duplicated column name when using join with Zend_Db_table

Question

Hi,

I have two tables. Both of them have a column named 'title'. When I use the following code snippet to join two tables, I can't access one of the title column.

 $select = $this->select(Zend_Db_Table::SELECT_WITH_FROM_PART);
 $select->setIntegrityCheck(false);
 $select->join("service","service.id = lecture.service_id");
 return $select;

is there a way to access both columns?

Answer 1

$select = $this->select();
$select->from(array('t'=>'table1'), array('table_title AS title_first','table_sendo_colun','table_third_colun'));
$select->setIntegrityCheck(false);
$select->join("service","service.id = t.service_id");
return $select;

Maybe It can do the job.

Regard´s.