At 22:45 -0400 9/18/02, Rob Hutton wrote: >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.
You'll need to specify the names you want displayed explicitly. > >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
