Member Avatar for saadi06

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.

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 1 Reply
  • 39 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

AS should come after:

SELECT value AS columnA FROM table2 WHERE nr=55
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.