estiens

Keybase proof

I hereby claim:

• I am estiens on github.
• I am estiens (https://keybase.io/estiens) on keybase.
• I have a public key ASA_2jFesdWj21LwoMjHfpFnM8j8tZREqQWfLLUmerg3fgo

To claim this, I am signing this object:

estiens

Keybase proof

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:

estiens

*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