SELECT     dbo.FUNDS.FundID, dbo.FUNDS.FundName AS [Fund Name], dbo.TrackRecord.AsOfDate AS [Track Record As of Date], 
                      dbo.TrackRecord.OriginDate AS [Track Record Origin Date], dbo.TrackRecord.[Size] AS [Track Record Fund Size], 
                      dbo.TrackRecord.Companies AS [Number Of Companies], dbo.TrackRecord.Capital AS [Track Record Capital], 
                      dbo.TrackRecord.Proceeds AS [Track Record Proceeds], dbo.TrackRecord.[Value] AS [Track Record Fund Value], 
                      dbo.TrackRecord.IRRReal AS [Track Record IRREAL], dbo.TrackRecord.IRROverall AS [Track Record IRROVERALL], 
                      dbo.TrackRecord.GMReal AS [Track Record GMREAL], dbo.TrackRecord.GMOverall AS [Track Record GMOVERALL], 
                      dbo.TrackRecord.RRReal AS [Track Record RRREAL], dbo.TrackRecord.RROverall AS [Track Record RROVERALL], 
                      dbo.TrackRecord.MultipleReal AS [Track Record MultipleReal], dbo.TrackRecord.MultipleOverall AS [Track Record MultipleOverall], 
                      dbo.TrackRecord.Relevant, dbo.TrackRecord.AdditionalFunds, dbo.Salutation.Salutation AS [Fund MNGT Salutation], 
                      dbo.FUNDMNGT.FirstName AS [Fund MNGT First Name], dbo.FUNDMNGT.LastName AS [Fund MNGT Last Name], 
                      dbo.FUNDMNGT.Title AS [Fund MNGT Title], dbo.FUNDMNGT.Age, dbo.FUNDMNGT.YOS, dbo.FUNDMNGT.Member, dbo.FUNDMNGT.Seats, 
                      dbo.FUNDMNGT.Deals, dbo.FUNDMNGT.Diligence, dbo.FUNDMNGT.Negotiating, dbo.FUNDMNGT.Monitoring, dbo.FUNDMNGT.Other, 
                      dbo.FUNDMNGT.Experience, dbo.FUNDMNGT.Employment, dbo.FUNDMNGT.Education, dbo.FUNDMNGT.LastMGR, dbo.FUNDS.Placement_Agent, 
                      Salutation1.Salutation, dbo.FUNDS.FirstName, dbo.FUNDS.LastName, dbo.FUNDS.Title, dbo.FUNDS.Firm, dbo.FUNDS.Address1, dbo.FUNDS.Address2, 
                      dbo.FUNDS.state, dbo.FUNDS.City, dbo.Country.CountryName, dbo.FUNDS.PostalCode, dbo.FUNDS.Phone, dbo.FUNDS.Fax, dbo.FUNDS.Email, 
                      dbo.FUNDS.WebAddress, dbo.FUNDS.GPLastName, dbo.FUNDS.GPTitle, Salutation2.Salutation AS GPSalutation, dbo.FUNDS.GPFirstName, 
                      dbo.FUNDS.GPFirm, dbo.FUNDS.GPAddress1, dbo.FUNDS.GPAddress2, dbo.FUNDS.GPCity, dbo.FUNDS.GPstate, 
                      Country_1.CountryName AS GPCountry, dbo.FUNDS.GPPostalCode, dbo.FUNDS.GPPhone, dbo.FUNDS.GPFAX, dbo.FUNDS.GPEmail, 
                      dbo.FUNDS.GPWeb, dbo.FUNDS.DateRecieved, dbo.FUNDS.Closing, dbo.FUNDS.ClosingDate, dbo.FUNDS.CloseTrgtDate, 
                      dbo.FUNDS.TrgtFnlCloseDate, dbo.FUNDS.Currency, dbo.FUNDS.FundSize, dbo.FUNDS.HardCmts, dbo.FUNDS.SoftCmts, dbo.FUNDS.LPInvestors, 
                      dbo.FUNDS.AffFunds, dbo.FUNDS.Assets, dbo.FUNDS.TrgtGrsIRR, dbo.InvestmentStrategies.InvestmentStrategy AS [Primary Investment Strategy], 
                      InvestmentStrategies1.InvestmentStrategy AS [Secondary Investment Strategy], dbo.FUNDS.FstTimeFund AS [First Time Fund], dbo.FUNDS.LPInvOpps, 
                      dbo.FUNDS.WMOIF, dbo.FUNDS.SBIC, dbo.FUNDS.IndFocus AS [Industry Focus], dbo.FUNDS.StrategyDesc, dbo.FUNDS.LeadInv AS [Lead Investor], 
                      dbo.Investment_Size.InvestmentSize, dbo.Enterprise_Value.EnterpriseValue, dbo.Funding_Stages.FundingStage, 
                      dbo.Number_of_Investment_Targets.InvestmentTargetText, dbo.FUNDS.Controller, dbo.FUNDS.SameTeam, dbo.FUNDS.TeamChanges, 
                      dbo.FUNDS.Refrnces, dbo.FUNDS.Factors, dbo.FUNDS.PrimeSource, dbo.FUNDS.MngtComments, dbo.FUNDS.TeamLongevity, 
                      dbo.FUNDS.TrackRecord, dbo.FUNDS.TRComments AS [Track Record Comments], dbo.FUNDS.MGMTFeeDuring, dbo.FUNDS.MGMTFeeDuringBase, 
                      dbo.FUNDS.MGMTFeeAfter, dbo.FUNDS.MGMTFeeAfterBase, dbo.FUNDS.AdditiveFees, dbo.FUNDS.Cap, dbo.FUNDS.AdditiveTypes, 
                      dbo.FUNDS.CarriedIr, dbo.FUNDS.PreferredIr, dbo.FUNDS.CapAmount, dbo.FUNDS.OrgExpense, dbo.FUNDS.KeyMan, dbo.FUNDS.Clawback, 
                      dbo.FUNDS.NoFaultLPTerm, dbo.FUNDS.Jurisdiction, dbo.FUNDS.InvPeriod, dbo.FUNDS.Term, dbo.FUNDS.GPContPerc, dbo.FUNDS.GPContForm, 
                      dbo.FUNDS.LPs, dbo.FUNDS.LPClosed, dbo.FUNDS.CredentialConfirm, dbo.FUNDS.DateComplete, dbo.FUNDS.DateAdded, dbo.FUNDS.PPMID, 
                      dbo.FUNDS.Reviewer, dbo.FUNDS.SubmittalComments, dbo.FUNDS.attributes, dbo.FUNDS.Issues, dbo.Geographic_Region.Geographic_Region, 
                      dbo.TrackRecord.TrackRecordID, dbo.FUNDMNGT.FundManagementID
FROM         dbo.Geographic_Region RIGHT OUTER JOIN
                      dbo.FUNDS ON dbo.Geographic_Region.GeographicID = dbo.FUNDS.GeoFocus LEFT OUTER JOIN
                      dbo.Country Country_1 ON dbo.FUNDS.GPCountry = Country_1.CountryKey LEFT OUTER JOIN
                      dbo.Number_of_Investment_Targets ON dbo.FUNDS.InvTrgts = dbo.Number_of_Investment_Targets.InvestmentTargetID LEFT OUTER JOIN
                      dbo.Funding_Stages ON dbo.FUNDS.FundingStage = dbo.Funding_Stages.FundingStageID LEFT OUTER JOIN
                      dbo.Enterprise_Value ON dbo.FUNDS.EntValue = dbo.Enterprise_Value.EnterprisevalueID LEFT OUTER JOIN
                      dbo.Investment_Size ON dbo.FUNDS.InvSize = dbo.Investment_Size.InvestmentSizeID LEFT OUTER JOIN
                      dbo.Country ON dbo.FUNDS.Country = dbo.Country.CountryKey LEFT OUTER JOIN
                      dbo.InvestmentStrategies InvestmentStrategies1 ON dbo.FUNDS.SecStrategy = InvestmentStrategies1.InvStrategyID LEFT OUTER JOIN
                      dbo.InvestmentStrategies ON dbo.FUNDS.PrimeStrategy = dbo.InvestmentStrategies.InvStrategyID LEFT OUTER JOIN
                      dbo.Salutation Salutation2 ON dbo.FUNDS.GPSalutation = Salutation2.SalutationID LEFT OUTER JOIN
                      dbo.Salutation Salutation1 ON dbo.FUNDS.Salutation = Salutation1.SalutationID LEFT OUTER JOIN
                      dbo.Salutation RIGHT OUTER JOIN
                      dbo.FUNDMNGT ON dbo.Salutation.SalutationID = dbo.FUNDMNGT.Salutation ON dbo.FUNDS.FundID = dbo.FUNDMNGT.FundID LEFT OUTER JOIN
                      dbo.TrackRecord ON dbo.FUNDS.FundID = dbo.TrackRecord.FundID