UFN_SITEID_MAPFROM_EVENTREGISTRANTSPEAKERID

            create function dbo.UFN_SITEID_MAPFROM_EVENTREGISTRANTSPEAKERID  
            (  
                @REGISTRANTID uniqueidentifier  
            )   
            returns table
            as  
            return  
                select 
                    EVENTSITE.SITEID   
                from 
                    dbo.EVENTSPEAKER
                    inner join dbo.REGISTRANT on REGISTRANT.CONSTITUENTID = EVENTSPEAKER.CONSTITUENTID and REGISTRANT.EVENTID = EVENTSPEAKER.EVENTID
                    left outer join dbo.EVENTSITE on EVENTSPEAKER.EVENTID = EVENTSITE.EVENTID  
                where 
                    REGISTRANT.ID = @REGISTRANTID;