17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT U.USERNAME,
NVL ((SELECT 1
FROM USERATTENTION UA1
WHERE UA1.TOUSER = U.USERID
AND UA1.FROMUSER = UA.TOUSER),
0) AS ASEACHATTENTION
FROM T_USER U, USERATTENTION UA
WHERE UA.FROMUSER = U.USERID
AND UA.TOUSER = 3;
SELECT U.USERNAME,
NVL((SELECT 1
FROM USERATTENTION UA
WHERE UA.TOUSER = U.USERID
AND UA.FROMUSER = 3),
0) AS EACHATTENTION
FROM T_USER U
WHERE U.USERID IN
(SELECT UA.FROMUSER FROM USERATTENTION UA WHERE UA.TOUSER = 3);
select distinct username from usert u,useraction a where userid in (select touser from useraction) and userid