Quote:SELECT TOP 10 MR.MerchantContactFirstName + ' ' + MR.MerchantContactLastName AS MerchantName, AISLTrans.DeviceID,AISLTrans.TransactionID, AISLTrans.CardNumber, AISLTrans.TransactionDateTime, AISLTrans.TransactionStatus, AISTRNSTYPE.TransactionType AS TransactionRequestType,AISLTrans.TransactionAmount,(AISLTrans.BasePointEarn+AISLTrans.BonusPointEarn)AS 'Point Awarded'FROM AISLoyaltyTransactions AISLTrans INNER JOIN MerchantRegistration MR ON AISLTrans.MerchantID = MR.MerchantID INNER JOIN AISTransactionTypes AISTRNSTYPE ON AISLTrans.ProcessingCode = AISTRNSTYPE.ProcessingCode AND AISLTrans.TransactionType = AISTRNSTYPE.MessageType WHERE AISLTrans.TransactionType = 0200 AND AISLTrans.ProcessingCode = 071000 ORDER BY AISLTrans.TransactionDateTime DESC