On Wed, 18 Sep 2002 22:45:29 -0400, 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 > would select table1.*,table2.* from
do that? -z -- z, [EMAIL PROTECTED] on 09/18/2002 --------------------------------------------------------------------- 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