he may want "SELECT table1.* prefix t1,table2.* prefix t2" which not seems to be supported.
instead of "select table1.c1 as t1c1,table1.c2 as t1c2,........ table2.c1 as t2c2......" >From: z <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: Aliasing all fields >Date: Wed, 18 Sep 2002 19:51:16 -0700 > >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? 燜or 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 _________________________________________________________________ 享用世界上最大的电子邮件系统— MSN Hotmail。http://www.hotmail.com/cn --------------------------------------------------------------------- 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