resultset and two tables in sql query

bender

Is possible to read variable using table.fieldName like in example?

example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
table1.id = table2.id;

$rs = $this->dbc->query($sql->createSelect());
while($row=$rs->fetch_array()){
$retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
work
}