联查0908

SELECT h.HY_ID  hyId,h.DRAFTER_ID drafterId,h.DRAFTER_DEPT_ID drafterDeptId,dept.DEPT_NAME  drafterDeptName ,u.USER_NAME drafterName,h.APPLY_TIME applyTime,h.PHONE phone,IFNULL(h.PUB_FLAG,'') pubFlag,h.MEETING_NAME meetingName,
h.MEETING_ROOM meetingRoom,h.START_TIME startTime,h.END_TIME endTime
FROM  "REFO"."OA_TRANSAC_HYTZ" h left join "REFO"."ORG_USER" u on h.DRAFTER_ID=u.USER_ID left join 
"REFO"."ORG_DEPT" dept  on h.DRAFTER_DEPT_ID = dept.DEPT_ID order by START_TIME