UFN_FAF_COMPANYINDIVIDUALLIST_BY_COMPANYID

CREATE function dbo.UFN_FAF_COMPANYINDIVIDUALLIST_BY_COMPANYID
(
  @COMPANYID uniqueidentifier = NULL
)
returns table 
   as  

   return  
   (  
    select 
     TFT.NAME as TEAMNAME,    
     TE.TEAMFUNDRAISINGTEAMID as TEAMID, 
     C.keyname, 
     C.name,
     C.ID 
    from dbo.TEAMFUNDRAISINGTEAMMEMBER TM --get individuals under the company

    INNER JOIN dbo.TEAMEXTENSION TE
      ON TM.TEAMFUNDRAISINGTEAMID = TE.TEAMFUNDRAISINGTEAMID  
      AND TE.TYPECODE = 2  --company  

    INNER JOIN dbo.TEAMFUNDRAISINGTEAM TFT
      ON TM.TEAMFUNDRAISINGTEAMID = TFT.ID
    INNER JOIN dbo.TEAMFUNDRAISER TF
        ON TM.TEAMFUNDRAISERID = TF.ID
    INNER JOIN dbo.CONSTITUENT C
        ON TF.CONSTITUENTID = C.ID
    WHERE TM.TEAMFUNDRAISINGTEAMID = @COMPANYID
    )