UFN_SITEID_MAPFROM_BANKACCOUNTID

             CREATE function dbo.UFN_SITEID_MAPFROM_BANKACCOUNTID  
             (  
                @BANKACCOUNTID uniqueidentifier  
             )   
             returns table
             as  
            return
                (
                    select distinct CONSTITUENTSITE.SITEID
                    from dbo.BANKACCOUNT
          inner join dbo.BANK on BANK.ID = BANKACCOUNT.BANKID
          left outer join dbo.CONSTITUENTSITE on BANK.ID = CONSTITUENTSITE.CONSTITUENTID 
                    where BANKACCOUNT.ID = @BANKACCOUNTID
                )