2 xiaxiangqq xiaxiangqq 于 2014.09.04 15:55 提问

求问如何优化这段 最好用left join

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

Csdn user default icon
上传中...
上传图片
插入图片