I am running a query to pull the latest date in a table. However, I am getting multiple lines for the same record. Below is the query as I have constructed it. Any help would be greatly appreciated!
SELECT DISTINCT
b.MATTER_CODE, c.EMPLOYEE_NAME AS 'matter bill atty', a.GROUP_TYPE AS [MATTER RATES], d.CLIENT_CODE, d.CLIENT_NAME,
MAX(a.EFF_DATE) AS 'max eff date', b.MATTER_NAME, b.STATUS_CODE, c.EMPLOYEE_NAME,
a.MEMBER_TYPE AS [1=TKPR 2=RNK(MATT OFFC) 3=RNK(TKPR OFFC)], a.RANK_CODE, a.ALL_OFFICES, a.ALL_DEPTS, a.RATE
FROM TBM_RATE_FEE a INNER JOIN
HBM_MATTER b ON a.MATTER_UNO = b.MATTER_UNO INNER JOIN
HBM_CLIENT d ON b.CLIENT_UNO = d.CLIENT_UNO INNER JOIN
HBM_PERSNL c ON a.EMPL_UNO = c.EMPL_UNO
WHERE (a.GROUP_TYPE = 1) AND (b.INACTIVE = 'N') AND (b.STATUS_CODE = 'OPEN')
GROUP BY c.EMPLOYEE_NAME, a.GROUP_TYPE, d.CLIENT_CODE, d.CLIENT_NAME, b.MATTER_CODE, b.MATTER_NAME, b.STATUS_CODE,
c.EMPLOYEE_NAME, a.MEMBER_TYPE, a.RANK_CODE, a.ALL_OFFICES, a.ALL_DEPTS, a.RATE
ORDER BY d.CLIENT_CODE, b.MATTER_CODE, a.MEMBER_TYPE, c.EMPLOYEE_NAME