Exactly Rob Hutton Web Safe www.wsafe.com
********************************************************************** Introducing Symantec Client Security - Integrated Anti-Virus, Firewall, and Intrusion Detection for the Client. Learn more: http://enterprisesecurity.symantec.com/symes238.cfm?JID=2&PID=11624271 View our Symantec Client Security Demo: http://enterprisesecurity.symantec.com/symes238.cfm?JID=3&PID=11624271 Download the Symantec Client Security Fact Sheet: http://enterprisesecurity.symantec.com/symes238.cfm?JID=4&PID=11624271 Download the Symantec Client Security Brochure: http://enterprisesecurity.symantec.com/symes238.cfm?JID=5&PID=11624271 > -----Original Message----- > From: xuefer tinys [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 8:15 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Aliasing all fields > > > 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 > > --------------------------------------------------------------------- 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
