通达OA系统创建用户与HR试图的sql语句，左连接实例

select `u`.`USER_ID` AS `USER_ID`,`u`.`BYNAME` AS `BYNAME`,`u`.`USER_NAME` AS `USER_NAME`,`u`.`SEX` AS `SEX`,`u`.`BIRTHDAY` AS `BIRTHDAY`,`u`.`fuzhujuese` AS `FUZHUJUESE`,`u`.`longdeptname` AS `LONGDEPTNAME`,`u`.`MOBIL_NO` AS `MOBIL_NO`,`u`.`TEL_NO_DEPT` AS `TEL_NO_DEPT`,`u`.`NOT_LOGIN` AS `NOT_LOGIN`,`u`.`NOT_MOBILE_LOGIN` AS `NOT_MOBILE_LOGIN`,`a`.`WORK_TYPE` AS `WORK_TYPE`,`a`.`STAFF_CARD_NO` AS `STAFF_CARD_NO`,`a`.`ADMINISTRATION_LEVEL` AS `ADMINISTRATION_LEVEL`,`a`.`JOB_POSITION` AS `JOB_POSITION`,`a`.`PRESENT_POSITION` AS `PRESENT_POSITION`,`a`.`WORK_LEVEL` AS `WORK_LEVEL`,`b`.`CODE_NAME` AS `ZHICHENG`,`c`.`CODE_NAME` AS `ZHICHENGJIBIE` from (((`user` `u` left join `hr_staff_info` `a` on((`u`.`USER_ID` = `a`.`USER_ID`))) left join `hr_code` `b` on(((`a`.`PRESENT_POSITION` = `b`.`CODE_NO`) and (`b`.`PARENT_NO` = 'PRESENT_POSITION')))) left join `hr_code` `c` on(((`a`.`WORK_LEVEL` = `c`.`CODE_NO`) and (`c`.`PARENT_NO` = 'WORK_LEVEL'))))

select `u`.`USER_ID` AS `USER_ID`,`u`.`BYNAME` AS `BYNAME`,`u`.`USER_NAME` AS `USER_NAME`,`u`.`SEX` AS `SEX`,`u`.`BIRTHDAY` AS `BIRTHDAY`,`u`.`fuzhujuese` AS `FUZHUJUESE`,`u`.`longdeptname` AS `LONGDEPTNAME`,`u`.`MOBIL_NO` AS `MOBIL_NO`,`u`.`TEL_NO_DEPT` AS `TEL_NO_DEPT`,`u`.`NOT_LOGIN` AS `NOT_LOGIN`,`u`.`NOT_MOBILE_LOGIN` AS `NOT_MOBILE_LOGIN`,`a`.`WORK_TYPE` AS `WORK_TYPE`,`a`.`STAFF_CARD_NO` AS `STAFF_CARD_NO`,`a`.`ADMINISTRATION_LEVEL` AS `ADMINISTRATION_LEVEL`,`a`.`JOB_POSITION` AS `JOB_POSITION`,`a`.`PRESENT_POSITION` AS `PRESENT_POSITION`,`a`.`WORK_LEVEL` AS `WORK_LEVEL`,`b`.`CODE_NAME` AS `ZHICHENG`,`c`.`CODE_NAME` AS `ZHICHENGJIBIE` from (((`user` `u` left join `hr_staff_info` `a` on((`u`.`USER_ID` = `a`.`USER_ID`))) left join `hr_code` `b` on(((`a`.`PRESENT_POSITION` = `b`.`CODE_NO`) and (`b`.`PARENT_NO` = 'PRESENT_POSITION')))) left join `hr_code` `c` on(((`a`.`WORK_LEVEL` = `c`.`CODE_NO`) and (`c`.`PARENT_NO` = 'WORK_LEVEL'))))