ity 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: R
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]>, <[EMA
At 19:51 -0700 9/18/02, z wrote:
>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 wan
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.
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
