I want to use a one liner to get the Managers name along with the employees name. the Managers ID is txtManagerEnterpriseID
this T-SQL returns a NULL for Manager name right now.
can someone help me figure this out?
TIA
this T-SQL returns a NULL for Manager name right now.
can someone help me figure this out?
Code:
Select txtEnterpriseID,txtGivenname, txtSurname, txtCity ,txtManagerEnterpriseID ,
([highlight #FCE94F]Select (txtGivenname + ' ' + txtSurname) from VLDAP Where
txtEnterpriseID =txtManagerEnterpriseID) AS Managername[/highlight]
from VLDAP
Where txtGivenname like 'st%'
And txtSurname like 'Cornell'
TIA