in reply to fetchrow_hashref, and table.column format

I would use option 2, but i like using the AS alias. 

SELECT address_1 as 'address.address_1',
    city as 'address.city',
    state as 'address.state',
...

[download]
Another option might be to override fetchrow_array() and append the table name to the column names, but what happens when you join to other tables? I think it's better to do the work in the SQL statement.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

In Section Seekers of Perl Wisdom