SELECT statement

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

You pretty much just did it didn't you?

Code: Select all

 
SELECT
 Column1,
 Column2,
 [Column3] = (SELECT Column3 FROM table2 WHERE x=y),
 Column4
FROM dbo.table1
WHERE x=y

Would be better to see if you can acheive it with a join instead though...

Code: Select all

 
SELECT Column1,
 Column2,
 [Column3] b.Column3,
 Column4
FROM dbo.table1 As A
 LEFT OUTER JOIN dbo.table2 As B
  ON B.x = ?
WHERE x=y