Re: Aliasing all fields

[Paul DuBois]

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