UFN_SITEID_MAPFROM_REGISTRANTLODGINGID

            create function dbo.UFN_SITEID_MAPFROM_REGISTRANTLODGINGID(@REGISTRANTLODGINGID uniqueidentifier)   
            returns table
            as  
            return
                select EVENTSITE.SITEID   
                from 
                    dbo.REGISTRANTLODGING
                    inner join dbo.REGISTRANT on REGISTRANTLODGING.REGISTRANTCONSTITUENTID = REGISTRANT.CONSTITUENTID
                    left outer join dbo.EVENTSITE on REGISTRANT.EVENTID = EVENTSITE.EVENTID  
                where REGISTRANTLODGING.ID = @REGISTRANTLODGINGID;