Beginners question Aliased Columns

Gary Taylor · #1 (**permalink**) 02-09-04, 04:29

Hi I'm having trouble in referring to an aliased column name in my query.

SELECT 1 as v1, v1+1 as v2;

Can anyone tell me how to do this please?

aus · #2 (**permalink**) 02-09-04, 09:50

Try this instead:

Code:

SELECT @v1:=1 as v1, @v1+1 as v2;

This will assign the user variable @v1 the value of v1 for each record. I am not sure why you cannot refer to aliased columns within the column selection portion of the statement.

Internet Services

Web Development

Digital Marketing

Consumer Tech