SELECT
(
SELECT TOP ( 1 )
FeedbackResult
FROM dbo.PTA_InterviewFeedback
WHERE ( RequirementCandidateId = dbo.PTA_Requisition_Candidate.Id )
AND ( InterviewType = 'Final Interview' )
ORDER BY CreateDate DESC
)
AS CustomerInterviewResult
FROM dbo.PTA_Requisition_Candidate