Quick nested SQL question

[Bakedgoods]

How can I give a nested select statement a column name? I'd like the column name for the nested field to be CodeName..

SELECT ID, TimeCode, (SELECT CodeName FROM tblCodes WHERE tblHours.TimeCode = tblCodes.CodeID), Hours, Date, UserName, Comments, Approved FROM tblHours

At the moment it shows as "No column name" and I need to have one so I can bind data a ASP.net control to it.

 

[Visage]

How can I give a nested select statement a column name? I'd like the column name for the nested field to be CodeName..

SELECT ID, TimeCode, (SELECT CodeName FROM tblCodes WHERE tblHours.TimeCode = tblCodes.CodeID), Hours, Date, UserName, Comments, Approved FROM tblHours

At the moment it shows as "No column name" and I need to have one so I can bind data a ASP.net control to it.

You can use 'as', cant you?

SELECT ID, TimeCode, (SELECT CodeName FROM tblCodes WHERE tblHours.TimeCode = tblCodes.CodeID) as SomeColumnName, Hours, Date, UserName, Comments, Approved FROM tblHours

 

[Bakedgoods]

You can use 'as', cant you?

SELECT ID, TimeCode, (SELECT CodeName FROM tblCodes WHERE tblHours.TimeCode = tblCodes.CodeID) as SomeColumnName, Hours, Date, UserName, Comments, Approved FROM tblHours

Spot on thanks, I knew it would be something simple