I have this query and I'm getting duplicates rows. I tried using GROUP BY and ORDER BY but I still get duplicate rows. Any help is HIGHLY appreciated!!!
SELECT A.NAME, A.INTEGRATION_ID AS OBA_KEY, B.LOGIN AS EMP_LOGIN, C.BUSCOMP_NAME AS BUS_COMP, D.FIELD_NAME AS FIELD, C.OPERATION_CD AS OPERATION, C.OLD_VAL, C.NEW_VAL, C.CREATED AS CREATED, C.RECORD_ID, C.AUDIT_SOURCE_CD AS SOURCE, C.BC_BASE_TBL AS BASE_TABLE, D.COL_NAME, C.AUDIT_LOG FROM SIEBEL.S_AUDIT_ITEM C
LEFT JOIN SIEBEL.S_AUDIT_FIELD D ON SAF.CREATED_BY = C.CREATED_BY
LEFT JOIN SIEBEL.S_USER B ON C.CREATED_BY = B.CREATED_BY
LEFT JOIN SIEBEL.S_ORG_EXT A ON C.TBL_RECORD_ID = A.PAR_ROW_ID
WHERE C.CREATED > (CURRENT_DATE - 10);