ugh.. i can't remember this.. but when you do a join in an sql satatement and if you don't get a match on the join field how do you display a different value in its place?? so I have 2 tables.. tblCoaching and tblEmployees

so i have a stamement like this
Code:
SELECT tblCoaching.RecordID, tblCoaching.UserID, tblCoaching.EntererID, tblEmployees.NameLastFirst
FROM tblCoaching LEFT JOIN tblEmployees ON tblCoaching.EntererID = tblEmployees.UserId
but if the user was deleted from tblEmployees I want to display just the userid from the coaching table... how do i do this again?? i thoguht it was with a null check or something