Hello all. I have this PIVOT statement:

Code:
SELECT *, 
       Isnull([2011], 0) + Isnull([2012], 0) + Isnull([2013], 0) AS 
       [Gesamt Total] 
FROM   (SELECT anf.anf_id, 
               anf.titel, 
               ang.angebotsnummer, 
               ang.angebotstitel, 
               anf.fachbereich     AS [Fachbereich (Anf.)], 
               ang.fachbereich     AS [Fachbereich (Angeb.)], 
               anf.status, 
               ang.[Frist-IT-Org], 
               ang.angebot_beendet, 
               ang.[Aktuelles Vertragsende], 
               ang.[Künd/Nachb_Notwendig], 
               ang.[Datum Genehmigungsstatus], 
               ang.[IT-Org-Ansprechpartner], 
               anf.[In Bearbeitung bei], 
               lief.bezeichnung    AS [Lieferant], 
               ang.erfassungsdatum,
               anf.Anforderungs_Partner AS [Dienstleister 1],
               anf.Anforderungs_Partner_2 AS [Dienstleister 2],
               anf.Anforderungs_Partner_3 AS [Dienstleister 3], 
               anf.budgetclusterid AS [BudgetCluster (Anf.)],               
               ang.budgetclusterid AS [BudgetCluster (Angeb.)], 
               anf.steeringboard   AS [SteeringBoard (Anf.)], 
               ang.steeringboard   AS [SteeringBoard (Ang.)], 
               anp.gesamt_gj, 
               anp.jahr
               
        FROM   dbo.tbl_angebote AS ang 
               LEFT JOIN dbo.tbl_lieferanten AS lief 
                 ON ang.lieferant = lief.lieferant 
               LEFT JOIN dbo.tbl_anforderungen AS anf 
                 ON ang.anf_id = anf.anf_id 
               LEFT JOIN dbo.tbl_angebotsplanung AS anp 
                 ON ang.angebotsnummer = anp.angebotsnummer 
               LEFT JOIN dbo.tbl_budgetcluster 
                 ON ang.budgetclusterid = dbo.tbl_budgetcluster.budgetclusterid)
        AS 
       sourcetable PIVOT ( SUM( gesamt_gj) FOR [JAHR] IN ([2011], [2012], [2013]
        ) )AS 
       pvt
My problemt is that for BudgetCluster, I do not need to show the ID, but the actual name. BudgetCluster table has just the ID and Name. Right now my PIVOT shows just the id and I have been having a hard time to get the BudgetCluster Name. Any suggestions?