Sql In

使用Sql In 找出自已好友所建立的事件列表

SELECT     UserDataUniversitySchool, UserDataDepartment, UserDataSex, UserDataPhoto, EventDataName, EventDataEstablishDate, 
EventDataAssemblePosition, EventDataID, EventDataUID, UserDataNickName
FROM         dbo.vw_EventDataTimeLine
WHERE     (EventDataUID IN (SELECT UserFriendsAddUID FROM dbo.vw_FriendsShipDetail WHERE (UserFriendsUID = @uid) AND (UserFriendsIsConfirm = 1)))