Stuff

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