CREATE PROCEDURE dbo.[Forum_Attachment_GetAllByUserID] ( @UserID INT )
AS
    SELECT  A.[FileID],
            A.[PostID],
            A.[UserID],
            A.[LocalFileName],
            A.[Inline],
            F.[FileName],
            F.[Extension],
            F.[Size],
            F.[Width],
            F.[Height],
            A.[AttachmentID]
    FROM    dbo.Forum_Attachments A
            INNER JOIN dbo.Files F ON A.[FileID] = F.[FileId]
    WHERE   A.[UserID] = @UserID
            AND A.[PostID] = -1
    ORDER BY A.[FileID] DESC

GO