SELECT t1.InputItemValue AS CTime, t2.InputItemValue AS CDept,
t3.InputItemValue AS CUser, t4.InputItemValue AS CScore
FROM dbo.TBCheckRecord t1 INNER JOIN
dbo.TBCheckRecord t2 ON t1.SameID = t2.SameID INNER JOIN
dbo.TBCheckRecord t3 ON t1.SameID = t3.SameID INNER JOIN
dbo.TBCheckRecord t4 ON t1.SameID = t4.SameID