CREATE VIEW [iris_coll_view]
AS
select iris_data_coll.[IR_ID] AS IR_ID,iris_data_coll.[S_ID] AS S_ID,iris_data_coll.[TEL1] AS TEL1,iris_data_coll.[TEL2] AS TEL2,iris_data_coll.[DEV_TYPE] AS DEV_TYPE,iris_data_coll.[COLL_TIME] AS COLL_TIME,iris_data_coll.[DEV_CODE] AS DEV_CODE,iris_data_coll.[DEV_FIRM] AS DEV_FIRM,iris_data_coll.[FLG_CER] AS FLG_CER,iris_data_coll.[COLL_NUM] AS COLL_NUM,iris_data_coll.[FLG_WO] AS FLG_WO,iris_data_coll.[ST_ID] AS ST_ID,iris_data_coll.[COLL_NAME] AS COLL_NAME,iris_data_coll.[COLL_ID] AS COLL_ID,iris_data_coll.[COLL_REASON] AS COLL_REASON,iris_data_coll.[Q_L] AS Q_I,iris_data_coll.[Q_R] AS Q_R,iris_data_coll.[REASON_COLL_DESC] AS REASON_COLL_DESC,iris_data_coll.[PATH_CER] AS PATH_CER,iris_data_coll.[COLL_TYPE] AS COLL_TYPE,iris_data_coll.[DEF_REASON] AS DEF_REASON,iris_data_coll.[DEF_TYPE] AS DEF_TYPE,iris_data_coll.[IS_CER] AS IS_CER,iris_data_coll.[FLG_FORCE] AS FLG_FORCE,iris_data_coll.[FLG_SYNC] AS FLG_SYNC,iris_data_coll.[FLG_UPLOAD] AS FLG_UPLOAD,iris_data_coll.[UPLOAD_USER] AS UPLOAD_USER,iris_data_coll.[UPLOAD_TIME] AS UPLOAD_TIME,iris_data_coll.[RES_UPLOAD] AS RES_UPLOAD,iris_data_coll.[COLL_STATE] AS COLL_STATE,iris_data_coll.[COLL_WAY] AS COLL_WAY,iris_data_coll.[FLG_FOCUS] AS FLG_FOCUS,iris_data_coll.[FAIL_REASON] AS FALL_REASON,iris_data_coll.[PHOTO] AS PHOTOD,iris_data_coll.[COLL_SPEND] AS COLL_SPEND,iris_data_coll.[FLG_DEL] AS FLG_DEL,iris_data_coll.[COLL_PLACE] AS COLL_PLACE,iris_data_coll.[FOCUS_END_DATE] AS FOCUS_END_DATE,iris_data_coll.[FOCUS_REMARKS] AS FOCUS_REMARKS,iris_data_coll.[ST_NAME] AS ST_NAME,iris_data_coll.[ST_TYPE] AS ST_TYPE,iris_data_coll.[FLG_FORCE_PERSON] AS FLG_FORCE_PERSON,sys_person.[ID] AS ID,sys_person.[DELFLAG] AS DELFLAG,sys_person.[CREATETIME] AS CREATETIME,sys_person.[UPDATETIME] AS UPDATETIME,sys_person.[NAME] AS NAME,sys_person.[SEX] AS SEX,sys_person.[DEPTID] AS DEPTID,sys_person.[ID_CARD_NO] AS ID_CARD_NO,sys_person.[REMARKS] AS REMARKS,sys_person.[PERSON_TYPE] AS PERSON_TYPE,sys_person.[PERSON_CODE] AS PERSON_CODE,sys_person.[PHOTO] AS PHOTOP,sys_person.[OPRATION_ID] AS OPRATION_ID,sys_person.[DUTY] AS DUTY,sys_person.[NATION] AS NATION,sys_person.[BIRTHDAY] AS BIRTHDAY,sys_person.[CARD_TYPE] AS CARD_TYPE,sys_person.[PHOTO_DATA] AS PHOTO_DATA,sys_person_ext.[ID] AS IDE,sys_person_ext.[TARGET_ID] AS TARGET_ID,sys_person_ext.[COLUMN_1] AS [COLUMN_1],sys_person_ext.[COLUMN_2] AS COLUMN_2,sys_person_ext.[COLUMN_3] AS COLUMN_3,sys_person_ext.[COLUMN_4] AS COLUMN_4,sys_person_ext.[COLUMN_5] AS COLUMN_5,sys_person_ext.[COLUMN_6] AS COLUMN_6,sys_person_ext.[COLUMN_7] AS COLUMN_7,iris_data_coll.[ST_X] AS ST_X,iris_data_coll.[ST_Y] AS ST_Y,iris_data.[IMAGE_L1_DATA] AS IMAGE_L1_DATA,iris_data.[IMAGE_R1_DATA] AS IMAGE_R1_DATA,iris_data.[IR_ID] AS IR_ID_DT,iris_data.[S_ID] AS S_ID_DT,iris_data.[IMAGE_L1] AS IMAGE_L1,iris_data.[IMAGE_L2] AS IMAGE_L2,iris_data.[IMAGE_R1] AS IMAGE_R1,iris_data.[IMAGE_R2] AS IMAGE_R2 from (((iris_data_coll join sys_person) join sys_person_ext) join iris_data) where ((sys_person.[ID] = iris_data_coll.[S_ID]) and (sys_person_ext.[TARGET_ID] = sys_person.[ID]) and (iris_data.[S_ID] = sys_person.[ID]))