I'm running into a snag... here's an example of the query I'm making
from within Perl:
SELECT * FROM table1,table2
I know it's not a nice way to do it, but I'm making an SQL webpage
frontend which I'd like to support it just in case. I'm
using fetchrow->hashref to pull it out and display it. The problem I'm
running into is when table1 and table2 have similar
column names. One of them would be overwritten in the hash reference to
be replaced by the second one it encounters.
So my question is this. Is there any way to force MySQL to ouput the
table name with the column name instead of just the
column name, ie. table1.column2.
Thanks in advance,
Dave Mittner
---------------------------------------------------------------------
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
