01.select em_creatmeet.MEETTIMEID,em_creatmeet.COMMITID,em_creatmeet.TIMEID,em_creatmeet.PLACE,em_creatmeet.CMDATE,
02.em_creatmeet.STIME1,em_creatmeet.FTIME1,em_creatmeet.STIME2,em_creatmeet.FTIME2,
03.cm_create_commit.COMMITID,cm_create_commit.SUBJECT,
04.em_creatdata.MEETTIMEID,em_creatdata.MAINDATA,em_creatdata.SECONDDATA,em_creatdata.THIRDDATA,
05.em_fixlistname.MEETTIMEID,em_fixlistname.F1,em_fixlistname.F2,em_fixlistname.F3,em_fixlistname.F4,em_fixlistname.F5,
06.em_listname.ATTENDNAMEID,em_listname.LISTNAMEID,em_listname.MEETTIMEID,
07.em_meeting.SCHECKID,em_meeting.MEETINGID,em_meeting.MDETAIL,em_meeting.EMPLOYEEID,em_meeting.DATELINE,em_meeting.DATEASSIGN,em_meeting.CREATEDATAID,em_meeting.CHKOTHER,
08.em_chkmeet.SCHECKID,em_chkmeet.CHKMEET,
09.
10.cm_positiong.POSITIONGID
11.from em_creatmeet
12.inner join em_creatdata on em_creatdata.MEETTIMEID = em_creatmeet.MEETTIMEID
13.inner join em_meeting on em_meeting.CREATEDATAID = em_creatdata.CREATEDATAID
14.inner join em_chkmeet on em_meeting.SCHECKID = em_chkmeet.SCHECKID
15.inner join em_fixlistname on em_creatdata.MEETTIMEID = em_fixlistname.MEETTIMEID
16.inner join em_listname on em_listname.ATTENDNAMEID = em_fixlistname.ATTENDNAMEID
17.inner join cm_create_commit on em_creatmeet.COMMITID = cm_create_commit.COMMITID
18.inner join cm_nameingroup on em_creatmeet.COMMITID = cm_nameingroup.COMMITID
19.inner join VW_HRIS_EMPLOYEE on cm_nameingroup.EMPLOYEEID = VW_HRIS_EMPLOYEE.EMPLOYEEID
20.inner join cm_positiong on cm_positiong.POSITIONGID = cm_nameingroup.POSITIONGID
21.where em_creatmeet.timeid =
