It is just easy. Plz check
SELECT e.UserID, e.DeviceID, e.EventName, e.EventTime, p.amount, p.color FROM EventTable e JOIN PurchaseTable p ON e.EventName = p.purchase_code;