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

Reply via email to