SELECT DISTINCT 
	P.PlayerID, 
	P.Acct, 
	P.Title, 
	P.FirstName, 
	P.LastName, 
	P.HomeAddr1, 
	P.HomeAddr2, 
	P.HomeCity, 
	P.HomePostalCode, 
	P.HomeCountryCode, 
	P.HomeTel1Type, 
	P.HomeTel1, 
	P.HomeTel2Type, 
	P.HomeTel2, 
	P.IsSMSSend, 
	P.HomeEmail, 
	P.IsEmailSend, 
	P.BirthDt, 
	P.TypeID, 
	P.IsVIP, 
	P.IsBanned, 
	P.IsProblemGambler, 
	P.IsNoMail, 
	P.IsReturnMail, 
	P.IsMailToAlt, 
	P.Sex, 
	P.SetupCasinoID, 
	P.SetupDtm, 
	P.MaxTrpCasinoId, 
	P.PtsBal, 
	P.LastTripDt, 
	P.LTDPts, 
	P.HostEmpID, 
	P.SetupEmpID, 
	P.LastEditDtm, 
	P.LastEditEmpID, 
	P.PlayerID, 
	P.GroupID, 
	A.ActionD, 
	A.TheorWin, 
	A.CashbuyIn, 
	A.ChipBuyIn, 
	A.BuyIn, 
	A.CasinoWin, 
	A.Bet, 
	A.EarnedPts, 
	A.BonusPts, 
	A.RedeemPts, 
	A.AdjPtsDr, 
	A.AdjPtsCr, 
	A.NetPts, 
	A.EarnedComp, 
	A.AdjCompDr, 
	A.AdjCompCr, 
	A.CompSpent, 
	A.Unusedcomp, 
	A.RatingPeriodMinutes, 
	A.PlayTimeHours, 
	A.AvgBetPerPlay, 
	A.Trips, 
	A.AuthAward, 
	A.AwardUsed, 
	A.UnsettledAward, 
	A.Food, 
	A.Travel, 
	A.Merchandise, 
	A.OtherAward, 
	A.CompUsed, 
	A.CasinoID, 
	X.ClubADW 
FROM   
	dbo.ViewCustomers P 
INNER JOIN 
	(
		SELECT 
			PlayerID, 
			Sum(ActionDays)          AS ActionD, 
			Sum(TheorWin)            AS TheorWin, 
			Sum(CashBuyIn)           AS CashbuyIn, 
			Sum(ChipBuyIn)           AS ChipBuyIn, 
			Sum(BuyIn)               AS BuyIn, 
			Sum(CasinoWin)           AS CasinoWin, 
			Sum(Bet)                 AS Bet, 
			Sum(EarnedPts)           AS EarnedPts, 
			Sum(BonusPts)            AS BonusPts, 
			Sum(RedeemPts)           AS RedeemPts, 
			Sum(AdjPtsDr)            AS AdjPtsDr, 
			Sum(AdjPtsCr)            AS AdjPtsCr, 
			Sum(NetPts)              AS NetPts, 
			Sum(EarnedComp)          AS EarnedComp, 
			Sum(AdjCompDr)           AS AdjCompDr, 
			Sum(AdjCompCr)           AS AdjCompCr, 
			Sum (CompSpent)          AS CompSpent, 
			Sum(UnusedComp)          AS Unusedcomp, 
			Sum(RatingPeriodMinutes) AS RatingPeriodMinutes, 
			Sum(PlayTimeHours)       AS PlayTimeHours, 
			Sum(AvgBetPerPlay)       AS AvgBetPerPlay, 
			Sum(Trips)               AS Trips, 
			Sum(AuthAward)           AS AuthAward, 
			Sum(AwardUsed)           AS AwardUsed, 
			Sum(UnsettledAward)      AS UnsettledAward, 
			Sum(Food)                AS Food, 
			Sum(Travel)              AS Travel, 
			Sum(Merchandise)         AS Merchandise, 
			Sum(OtherAward)          AS OtherAward, 
			Sum(CompUsed)            AS CompUsed, 
			Sum (TheorWin)           AS ClubADW, 
			CasinoID 
		FROM   
			dbo.viewAccum1 
		WHERE  
			Accumulator = 'DP' 
		GROUP  BY 
			PlayerID, 
			CasinoID
	) A 
    ON P.PlayerID = A.PlayerID 
LEFT JOIN 
	dbo.ViewAccum1Day X 
    ON A.PlayerID = X.PlayerID  

SELECT DISTINCT 
	A.CasinoID, 
	X.ClubADW
FROM   
	dbo.ViewCustomers P 
INNER JOIN 
	(
		SELECT 
			Sum (TheorWin)           AS ClubADW, 
			CasinoID 
		FROM   
			dbo.viewAccum1 
	) A 
    ON P.PlayerID = A.PlayerID 
LEFT JOIN 
	dbo.ViewAccum1Day X 
    ON A.PlayerID = X.PlayerID