SELECT		i.SZ_ITEM_REF_NO AS ITEM_REF2,
		i.SZ_DESCRIPTION AS DESCR2,
		i.N0_DEPARTMENT_NO AS DEP2,
		SUM(i.N0_QUANTITY),
		i.N2_ORIG_PRICE AS OR_PRICE2,
		l.DT_TIME_STAMP_ST AS TIME2,
		l.N0_OPERATOR_NO AS OP,
		l.N0_UNIQUE_STR_NO AS STR,
		i.N0_PERIOD_NO AS PER
FROM		RDB_LOG AS l
INNER JOIN	RDB_LOG_ITEM AS i ON i.N0_OPERATOR_NO = l.N0_OPERATOR_NO
			AND i.N0_TERMINAL_NO = l.N0_TERMINAL_NO
			AND i.N0_XACT_NO = l.N0_XACT_NO
			AND i.N0_UNIQUE_STR_NO = l.N0_UNIQUE_STR_NO
			AND i.N0_PERIOD_NO = l.N0_PERIOD_NO
LEFT JOIN	RDB_LOG_DISCOUNT AS d ON AND d.N0_OPERATOR_NO = l.N0_OPERATOR_NO
			AND d.N0_TERMINAL_NO = l.N0_TERMINAL_NO
			AND d.N0_XACT_NO = l.N0_XACT_NO
			AND d.N0_UNIQUE_STR_NO = l.N0_UNIQUE_STR
			AND d.N0_PERIOD_NO = i.N0_PERIOD_NO
			AND d.N0_ITEM_ID_FROM = i.N0_ITEM_ID
			AND d.BL_DISC_ITEM = 1
WHERE		l.DT_TIME_STAMP_END IS NOT NULL
		AND l.N0_PERIOD_NO = '200712310000'
		AND l.BL_REFUND = 0
		AND l.BL_TRAINING = 0
		AND l.BL_VOIDED = 0
		AND l.BL_VOID_PREV = 0
		AND l.BL_SUSPENDED = 0
		AND l.N0_TRANS_TYPE IN (0, 82)
		AND l.N0_UNIQUE_STR_NO = 2
		AND i.BL_NO_MERCH_ITEM = 0
GROUP BY	i.SZ_ITEM_REF_NO,
		i.SZ_DESCRIPTION ,
		i.N0_DEPARTMENT_NO,
		i.N2_ORIG_PRICE,
		l.DT_TIME_STAMP_ST,
		l.N0_OPERATOR_NO,
		l.N0_UNIQUE_STR_NO,
		i.N0_PERIOD_NO
ORDER BY	i.SZ_ITEM_REF_NO,
		l.DT_TIME_STAMP_ST