var _List := (from arec in fDatamodule.DataAdapter.GetTable<lpv8oelib.Data.admanage>
              where (arec.InvoiceDate>=d1)
              where (arec.InvoiceDate<=d2)

              join brec in fDataModule.dataAdapter.GetTable<lpv8oelib.data.aprecbills>
              on new class(F1 := arec.ReconID,F2 := arec.ApplyToBill) equals new class(F1 := brec.ReconID,F2 := brec.BillNumber)

            join prec in fDatamodule.DataAdapter.GetTable<lpv8oelib.data.pubfile>
            on arec.PubNumber equals prec.PubNumber

            into pajoin

            from parec in pajoin
            select new class (AdNumber := arec.AdNumber,
                              EntryYear := arec.EntryYear,
                              ReconID := arec.ReconID,
                              BillNum := arec.ApplyToBill,
                              PayType := parec.PaymentType,
                              IsReconciled := arec.IsReconciled,
                              InvoiceNumber := arec.InvoiceNumber,
                              InvoiceDate := arec.InvoiceDate,
                              PubNumber := arec.PubNumber,
                              PubName := parec.PubName,
                              CheckDate := arec.CheckDate,
                              CheckNumber := arec.CheckNumber,
                              GrossBilled := arec.GrossBilled,
                              NetBilled := arec.NetBilled,
                              NetRecon := arec.NetRecon,
                              Revenue := arec.Revenue,
                              Margin := arec.Margin,
                              FullAdNumber := arec.AdNumber+arec.EntryYear )).ToList;