I tried putting this in the Display column named `Interviewer`, but it barfed at me.
Code: Select all
SELECT Display_name FROM Interviewers WHERE ID = Interviewer
Code: Select all
SELECT Display_name FROM Interviewers WHERE ID = Interviewer
Code: Select all
(SELECT ii.Display_name FROM Interviewers ii WHERE ii.ID = Interviewer)