Before , how to edit this query for show the after result ?
item discount_type discount_name
4895177031614 AYC'17-PA CLEARANCE SALE
4895177031614 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA
4895177031560 AYC'17-PA CLEARANCE SALE
4895177031560 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA
4895177033618 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA
4895177033618 AYC'17-PA CLEARANCE SALE
After result
item discount_type discount_name
4895177031614 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA / Clear sales
4895177031560 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA / Clear Sales
4895177033618 GET10%DISCO AYC'17-BUY 3 OR MORE GET 10% EXTRA / Clear Sales
SELECT
itembarcode,
discountcode,
discountname
FROM
DW_PURE01.dbo.AX_DailySales_v1_2
WHERE
transactionid='0000000084' and SaleDate = '2017-06-08'
Please email to me : yiuwanlungfelix@gmail.com