34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TID INT
SELECT USERNAME ,
ALLJF ,
QQID ,
ADDTIME ,
( SELECT STATE
FROM [TJRINFO]
WHERE TJRID = T.ID
) as [STATE]
FROM [USER] T
WHERE [ID] IN ( SELECT TJRID
FROM [TJRINFO]
WHERE TID = @TID )
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 )
select a.username,a.alljf,a.QQID,a.addtime,b.state
from [user] a
inner join [tjrinfo] b
on a.[id]=b.[tjrid]