Select Alias in query from database

Hi,
I have a select query. I want to make name of one column from database like this

select columnA as (SELECT value from table2 WHERE nr=55) FROM table1

Is this possible in mysql. I have tried to run the query but it is saying that something is wrong with the syntax.
Thanks in advance.

2

Contributors

1

Reply

1 Hour

Discussion Span

7 Months Ago

Last Updated

2

Views

Junior Poster in Training

96 posts since Oct 2010

Reputation Points: 12

Solved Threads: 2

Skill Endorsements: 1

0

AS should come after:

SELECT value AS columnA FROM table2 WHERE nr=55

Posting Prodigy

Moderator

9,285 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,457

Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead