Find Pricelist Duplicates Report - Khaos Control (Keystone Software)

FindPricelistDuplicates.sql

SELECT 
	sd.compclass_id as 'Pricelist ID',
	cc.short_desc as 'Pricelist',
	UPPER(st.stock_code) as 'SKU'

FROM struc_discounts AS sd

LEFT JOIN stock as st
	ON sd.stock_id = st.stock_id
LEFT JOIN company_class as cc
	on cc.compclass_id = sd.compclass_id

GROUP BY
	sd.compclass_id, 
	cc.short_desc, 
	st.stock_code

HAVING (count(st.stock_code) > 1 )

ORDER BY 
	sd.compclass_id, 
	st.stock_code
	asc