In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2 you get a listing like this. +----+----+ | f1 | f1 | +----+----+ | 1 | 1 | | 1 | 2 | | 1 | 3 | +----+----+ When using the DBI function fetchrow_hashref() you get only one value since the key is not unique. Is there a way to get MySQL to return with the syntax "TABLENAME.FIELDNAME", and not just "FIELDNAME" ? I know that you can use aliases to get a similar effect but it's a hassle to write sql's like this : SELECT table1.f1 as 'table1.f1',table2.f1 as 'table2.f1' FROM table1,table2 Regards Terje K WebOn AS Norway --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php