DECLARE @TID INT
SELECT  USERNAME ,
        ALLJF ,
        QQID ,
        ADDTIME ,
        ( SELECT    STATE
          FROM      [TJRINFO]
          WHERE     TJRID = T.ID
        )
FROM    [USER] T
WHERE   [ID] IN ( SELECT    TJRID
                  FROM      [TJRINFO]
                  WHERE     TID = @TID )