UFN_SITEID_MAPFROM_FAFPROGRAMID

    CREATE function dbo.UFN_SITEID_MAPFROM_FAFPROGRAMID  
            (  
            @FAFPROGRAMID uniqueidentifier  
            )   
            returns table
            as  
            return
                select FAFPROGRAMSITE.SITEID
                from dbo.[FAFPROGRAM]
                left outer join dbo.FAFPROGRAMSITE on FAFPROGRAMSITE.FAFPROGRAMID = [FAFPROGRAM].ID
                where [FAFPROGRAM].ID = @FAFPROGRAMID;