/* Powered by General SQL Parser (www.sqlparser.com) */

SELECT DISTINCT CRMCONTACTID.MAIL                 AS EMAIL,
                TBL_DIRECTORY.I_ID                AS ID,
                TBL_DIRECTORY.T_EMP_ID,
                TBL_AREA_1.AREACODE,
                CRMCONTACTID.TEL                  AS OFFICE_NO,
                TBL_AREA_2.AREACODE,
                CRMCONTACTID.HOMEPHONE            AS HOME_NO,
                TBL_AREA.AREACODE                 AS FAXAREACODE,
                CRMCONTACTID.FAX                  AS FAX_NO,
                CRMCONTACTID.HMOBILE              AS MOBILE_NO,
                TBL_ADMINDEPARTMENT.ADMINDEPTNAME AS ADMINDEPTNAME,
                TBL_DEPARTMENT.DEPTNAME           AS DEPARTMENTNAME,
                TBL_AREA_3.AREACODE,
                TBL_DIRECTORY.PHONENO_RAIL_O      AS PHONE_RAIL_O,
                TBL_AREA_4.AREACODE,
                TBL_DIRECTORY.PHONENO_RAIL_R      AS PHONE_RAIL_R,
                TBL_AREA_5.AREACODE,
                TBL_DIRECTORY.PHONENO_MTNL_O      AS PHONE_MTNL_O,
                TBL_AREA_6.AREACODE,
                TBL_DIRECTORY.PHONENO_MTNL_R      AS PHONE_MTNL_R,
                CRMCONTACTID.GIVENNAME            AS FNAME_E,
                CRMCONTACTID.SN                   AS LNAME_E,
                TBL_DIRECTORY.T_NAME_F_H          AS FNAME_H,
                TBL_DIRECTORY.T_NAME_L_H          AS LNAME_H,
                CRMCONTACTID.HSTREET              AS STREET,
                CRMCONTACTID.HCITY                AS CITY,
                CRMCONTACTID.HSTATE               AS STATE,
                TBL_DIRECTORY.DT_DATETILLPOST     AS DATETILLPOST,
                TBL_PRIORITY.T_PRIORITYNAME       AS PRIORITY,
                TBL_BRANCH.T_BRANCHNAME           AS BRANCH,
                TBL_HEADQUARTER.T_HQNAME          AS HEADQUARTER,
                TBL_RANK.T_RANKNAME               AS RANK
FROM   TBL_DIRECTORY
       INNER JOIN TBL_AREA AS TBL_AREA_1
         ON TBL_DIRECTORY.AREAID_O = TBL_AREA_1.AREAID
       INNER JOIN TBL_AREA AS TBL_AREA_2
         ON TBL_DIRECTORY.AREAID_H = TBL_AREA_2.AREAID
       INNER JOIN TBL_AREA AS TBL_AREA_3
         ON TBL_DIRECTORY.AREAID_RAIL_O = TBL_AREA_3.AREAID
       INNER JOIN TBL_AREA AS TBL_AREA_4
         ON TBL_DIRECTORY.AREAID_RAIL_R = TBL_AREA_4.AREAID
       INNER JOIN TBL_AREA AS TBL_AREA_5
         ON TBL_DIRECTORY.AREAID_MTNL_O = TBL_AREA_5.AREAID
       INNER JOIN TBL_AREA AS TBL_AREA_6
         ON TBL_DIRECTORY.AREAID_MTNL_R = TBL_AREA_6.AREAID
       INNER JOIN TBL_AREA
         ON TBL_DIRECTORY.AREAID_F = TBL_AREA.AREAID
       INNER JOIN CRMCONTACTID
         ON TBL_DIRECTORY.I_ID = CRMCONTACTID.ATXCONTACTID
       INNER JOIN TBL_PRIORITY
         ON TBL_DIRECTORY.I_PRIORITYID = TBL_PRIORITY.I_PRIORITYID
       INNER JOIN TBL_BRANCH
         ON TBL_DIRECTORY.I_BRANCHID = TBL_BRANCH.I_BRANCHID
       INNER JOIN TBL_HEADQUARTER
         ON TBL_DIRECTORY.I_HQID = TBL_HEADQUARTER.I_HQID
       INNER JOIN TBL_RANK
         ON TBL_DIRECTORY.I_RANK = TBL_RANK.I_RANKID
       INNER JOIN TBL_ADMINDEPARTMENT
         ON TBL_DIRECTORY.I_ADMINDEPT_ID = TBL_ADMINDEPARTMENT.ADMINDEPT_ID
       INNER JOIN TBL_DEPARTMENT
         ON CRMCONTACTID.DEPARTMENT = TBL_DEPARTMENT.DEPT_ID
WHERE  TBL_DIRECTORY.I_ID = TBL_DIRECTORY.I_ID