Is there a way to get MYSQL to alias all fields in a select even if there is no naming conflict? For instance, if I do a:
select * from table1, table2 where table1.t1c1 = table2.t2c2 then I want table1.t1c1 | table1.t1c2 | table1.t1c3 | table2.t2c1 | table2.t2c2 Not just the column names. Thanks, Rob Hutton Web Safe www.wsafe.com --------------------------------------------------------------------- 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