SELECT DISTINCT d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT
FROM         PRICEDISCTABLE AS d INNER JOIN
                      INVENTDIM AS i ON d.INVENTDIMID = i.INVENTDIMID INNER JOIN
                      CONFIGTABLE AS c ON i.CONFIGID = c.CONFIGID INNER JOIN
                      UNIT AS u ON d.UNITID = u.UNITID
WHERE     (((d.DATAAREAID) = 'lbs') AND ((d.RELATION) = 4) AND ((c.DATAAREAID) = 'lbs')) AND NOT (d.ITEMRELATION = 'PB045035H2F' AND d.UNITID = 'lm')
GROUP BY d.ITEMRELATION, c.CONFIGID, d.FROMDATE, d.TODATE, d.ACCOUNTCODE, d.ACCOUNTRELATION, d.AMOUNT, u.TXT
ORDER BY d.ITEMRELATION, c.CONFIGID;