I am trying to assign a field value [say column_B] from another table [say table_B] to a column name [say column_A] that is part of the query result set of table_A.

See example below.

SELECT A.Product, A.Customer, A.Vendor, ProductManager = (SELECT B.user_desc FROM TABLE B WHERE user_name = 'gecastill'), A.LaunchDate FROM TABLE A

How can I do that? I used to know how to do that but I have not done it in a year.

Please advise, thanks