试试这个：
DECLARE @TotalQuestions int;DECLARE @CorrectQuestions int;DECLARE @IncorrectQuestions int;SELECt @CorrectQuestions = COUNT( WiningComment) FROM Threads WHERe WiningComment IN (SELECt CommentsID FROM Comments WHERe UsersID=@UserID) SELECt @TotalQuestions = COUNT(CommentsID) FROM Comments WHERe UsersID=@UserID SELECT @IncorrectQuestions = (@TotalQuestions-@CorrectQuestions )Select @CorrectQuestions as 'WinningAnswers',@TotalQuestions as 'TotalAnswers',@IncorrectQuestions as 'IncorrectQuestions'
