ot; <[EMAIL PROTECTED]>
Cc: "Alvaro Cobo" <[EMAIL PROTECTED]>;
Sent: Sunday, June 12, 2005 1:11 PM
Subject: Re: Re-use a result field into a query
> Well Alvaro,
> you can use variables to re-use resultas like that :
>
> mysql> set @rs=0;
> Query OK, 0 rows a
---+
| 1 | 5 | 500 |
+---+-+-+
1 row in set (0.00 sec)
Mathias
Selon Jigal van Hemert <[EMAIL PROTECTED]>:
> From: "Alvaro Cobo" <[EMAIL PROTECTED]>
> To:
> Sent: Sunday, June 12, 2005 8:17 AM
> Subject: Re-use a result field into a quer
From: "Alvaro Cobo" <[EMAIL PROTECTED]>
To:
Sent: Sunday, June 12, 2005 8:17 AM
Subject: Re-use a result field into a query
> Is it possible to refer into a query to a result field from the same
query?.
> For example: a query which uses the field name of a result (alias) t
Hi guys. I´ve got a low-priority, non-important newbie question:
Is it possible to refer into a query to a result field from the same query?.
For example: a query which uses the field name of a result (alias) to create a
new field:
Select a.field1,
(a.field2+a.field3) AS result1,
(result1*1
