Select
top
100
State,JoinState,
( case when State = 1 and Joinstate = 0 then 2 when State = 1 and JoinState = 1 then 1 else 0 end ) as usestate from UserInfo
( case when State = 1 and Joinstate = 0 then 2 when State = 1 and JoinState = 1 then 1 else 0 end ) as usestate from UserInfo