Frage an die LINQ - Cracks

SELECT myPBtbl.Quelle, Right([Sortierdatum],4) AS Jahr, myPBtbl.[Debitor Nr], myPBtbl.Frankierlizenz, myPBtbl.Produkt
FROM (myPBtbl 
INNER JOIN myPBConv_KdDaten ON (myPBtbl.Frankierlizenz = myPBConv_KdDaten.Frankierlizenz) AND (myPBtbl.[Debitor Nr] = myPBConv_KdDaten.Debitor)) 
INNER JOIN myPBConv_Produkte ON (myPBConv_KdDaten.GlobeCustID = myPBConv_Produkte.GlobeCustID) AND (myPBtbl.Produkt = myPBConv_Produkte.myPBProdukt)
GROUP BY myPBtbl.Quelle, Right([Sortierdatum],4), myPBtbl.[Debitor Nr], myPBtbl.Frankierlizenz, myPBtbl.Produkt;

 Dim analyse = From report In myPBtbl _
                    Group report By quelle = report("quelle"), jahr = Strings.Right(report("Sortierdatum"), 4), debitor = report("Debitor Nr"), frankierlizenz = report("Frankierlizenz"), produkt = report("Produkt")  
                    Into g = Group _
                    Join dbKdInfos In myPBConv_KdDaten On frankierlizenz Equals dbKdInfos("Frankierlizenz") And debitor Equals dbKdInfos("Debitor") _  
                    Join dbPrInfos In myPBConv_Produkte On dbKdInfos("GlobeCustID") Equals dbPrInfos("GlobeCustID") And produkt Equals dbPrInfos("myPBProdukt") _  
                    Select New With {quelle, jahr, debitor, frankierlizenz, produkt, .Anzahl = g.Count, _
                                     .GlobeId = dbKdInfos("GlobeCustID"), .EndKunde = dbKdInfos("Referenz"), .GlobeProdukt = dbPrInfos("GlobeProdukt"), .OfferID = dbPrInfos("GlobeOfferID"), .OfferPos = dbPrInfos("OfferPosID")}