If this gives me the list of codes:
SELECT AUTHORIZATION_CODE FROM TBEMP_AUTH GROUP BY AUTHORIZATION_CODE HAVING COUNT(TBEMP_AUTH.AUTHORIZATION_CODE) >= 1;

Why doesn't this give me a row per code?:

select TBEMP.OFFICE_TYPE, TBEMP.EMP_POSITION, TBEMP.EMP_NAME, TBEMP.EMP_CODE, TBEMP.OFFICE_CODE, TBEMP_AUTH.AUTHORIZATION_CODE
2 FROM TBEMP, TBEMP_AUTH
3 WHERE TBEMP.EMP_CODE = TBEMP_AUTH.EMP_CODE AND AUTHORIZATION_CODE IN
4 (SELECT AUTHORIZATION_CODE FROM TBEMP_AUTH GROUP BY AUTHORIZATION_CODE HAVING COUNT(TBEMP_AUTH.AUTHORIZATION_CODE) >= 1)
5 AND TBEMP.EMP_STATUS = '0';