SELECT * FROM dbo.[USER] u,
(SELECT ua.User_Attention_Object_Id FROM dbo.User_Attention ua,dbo.[USER] u
WHERE u.User_Id=ua.User_Attention_User_Id AND ua.User_Attention_User_Id=3) uaid
WHERE u.User_Id=uaid.User_Attention_Object_Id
还望好心人帮我一下,感激不尽!!