CREATE PROCEDURE dbo.Forum_UserThreadsDeleteByForum
    @UserID int,
    @ForumID int
AS
    DELETE FROM Forum_UserThreads
    WHERE
        UserID = @UserID
        AND
        ThreadID IN
            (SELECT ThreadID
            FROM Forum_Threads
            WHERE ForumID=@ForumID)

GO