Eric Stiens estiens

I hereby claim:

To claim this, I am signing this object:

I hereby claim:

I am estiens on github.
I am estiens (https://keybase.io/estiens) on keybase.
I have a public key whose fingerprint is FB56 72FA B9C8 775A 4068 70EA 63D2 0395 675F 8549

To claim this, I am signing this object:

	client.rb#loyalty_points


	SELECT Points, TimeStamp, RewardType, RewardTypeID, tblClientRewards.ExpirationDate, tblClientRewards.Returned, Clients.FirstName, Clients.LastName, Clients.ClientID, [Sales].SaleID, [VISIT DATA].ClassID, [VISIT DATA].ClassDate, NULL AS PurchaseID
	FROM tblClientRewards
	LEFT OUTER JOIN Clients
	ON Clients.ClientID = tblClientRewards.RewardTypeID
	AND tblClientRewards.RewardType = 'Referral'
	LEFT OUTER JOIN [Sales]
	ON [Sales].SaleID = tblClientRewards.RewardTypeID