USP_EMAILFINDERRESUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_EMAILFINDERRESUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    select 
        EMAILFINDER.ID as EMAILFINDERID,
        EMAILFINDERFILE.REQUESTFILE,
        EMAILFINDER.FILENAME,
        EMAILFINDER.FILEUPLOADED,
        EMAILFINDER.FILEDOWNLOADED
    from 
        dbo.EMAILFINDERRESUBMITPROCESS
    inner join 
        dbo.EMAILFINDER on EMAILFINDER.ID = EMAILFINDERRESUBMITPROCESS.EMAILFINDERID
    inner join 
        dbo.EMAILFINDERFILE on EMAILFINDER.ID = EMAILFINDERFILE.ID
    where 
        EMAILFINDERRESUBMITPROCESS.ID = @ID;
end