SELECT F.FLDINT_ID, F.FLDINT_DATE, F.FLDINT_TYPE, (SELECT FT.DESCRIPTION FROM EJS_CODES FT WHERE FT.CODE = F.FLDINT_TYPE AND FT.CODE_TYPE = F.FLDINT_TYPE_TYPE) AS FLDINT_TYPE_DESC, F.AGENCY_CODE, (SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = F.AGENCY_CODE) AS AGENCY_DESC, F.SUMMARY, F.AGENCY_ONLY_YN, F.SECURITY_LEVEL, F.INTELL_ONLY_YN, JOIN(CURSOR(SELECT O.TITLE||' '||O.FNAME||' '||O.LNAME||'-'||O.INTERNAL_ID||'/'||ORC.ROLE_DESC FROM OFFICERS O, FLDINT_OFFICERS FO, OFFICER_ROLE_CODES ORC WHERE F.FLDINT_ID = FO.FLDINT_ID AND FO.OFFICER_ID = O.OFFICER_ID AND FO.ROLE_CODE = ORC.ROLE_CODE ),' | '), G.GANG_ID, GN.NAME, G.GANG_TYPE_CODE, (SELECT G.DESCRIPTION FROM EJS_CODES G WHERE G.CODE = G.GANG_TYPE_CODE AND G.CODE_TYPE = GANG_TYPE_CD_TYPE) AS GANG_TYPE_DESC, GN.NAME_TYPE_CODE FROM FIELD_INTERVIEWS F, GANGS G, GANG_NAMES GN, FLDINT_GANGS FG WHERE F.FLDINT_ID = FG.FLDINT_ID AND FG.GANG_ID = G.GANG_ID AND G.GANG_ID = GN.GANG_ID