-- group by select b.materialcode, b.materialname from orders a inner join material b on a.dealercode=b.dealercode and a.materialcode=b.materialcode and a.stockinday between '20180501' and '20180523' and a.storecode not in('9999') and a.storecode='2001' group by b.materialcode, b.materialname ; -- distinct select distinct b.materialcode, b.materialname from orders a inner join material b on a.dealercode=b.dealercode and a.materialcode=b.materialcode and a.stockinday between '20180501' and '20180523' and a.storecode not in('9999') and a.storecode='2001' ;