SELECT B.BUSINESS_NAME || '(' ||EC.DESCRIPTION||')'AS DISPLAY, B.BUSINESS_NUMBER AS VAL_1, NULL AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, IB.INC_INCIDENT_ID AS KEY_VAL_1, IB.SUPP_SEQ AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM INCIDENT_BUSINESSES IB INNER JOIN BUSINESSES B ON IB.BUSNS_BUSINESS_NUMBER = B.BUSINESS_NUMBER INNER JOIN EJS_CODES EC ON IB.IB1_ROLE_TYPE = EC.CODE AND IB.IB1_ROLE_TYPE_TYPE = EC.CODE_TYPE