select a.username,a.alljf,a.QQID,a.addtime,b.state from [user] a inner join [tjrinfo] b on a.[id]=b.[tjrid]
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 username,alljf,QQID,addtime ,t.[state] from [user] u join (select tjrid from [tjrinfo] where tid = @tid) t on u.id=t.tjrid
为什么查询出来的state sql里面显示 无名列
为什么查询出来的state sql里面显示 无名列
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 )
select a.username,a.alljf,a.QQID,a.addtime,b.state
from [user] a
inner join [tjrinfo] b
on a.[id]=b.[tjrid]
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 )
from [user] u
join (select tjrid from [tjrinfo] where tid = @tid) t on u.id=t.tjrid
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 )