change the way mysql returns columns to php zf 2 sql -

im getting using zend\db\sql.

the 2 tables share similar columns names, {id,name,...}

when access result set, column names overwritten because of this.

is there way mysql or zf2 return like:

'table1.id', 'table1.name', 'table2.id', table2.name'

so can filter there without having in query:

select 'table1.id table1_id', 'table1.name tablel1_name', 'table2.id table2_id', table2.name table2_name'

thanks!

Hide