飞的 发表于:2011-03-22 10:01:29
SELECT dbo_t_Emp.FNumber AS 工号, dbo_t_Emp.FName AS 姓名, [1人事_性别].FName AS 性别, [1部门].FName AS 部门, [1人事_职务].FName AS 职务, dbo_t_Emp.FHireDate AS 入职日期, dbo_t_Emp.FID AS 身份证号, dbo_t_Emp.FAddress AS 地址, [1人事_学历].FName AS 学历, dbo_t_Emp.FBirthday AS 出生日期, dbo_t_Emp.FPhone AS 电话, [1人事_账号].FBankAccount AS 银行账号, dbo_t_Emp.FEmail AS Email, dbo_t_Emp.FJobTypeID AS 工种, dbo_t_Emp.F_101 AS IC卡, [1人员属地].FName AS 人员属地, [1用工形式].FName AS 用工形式, [1工会会员].FName AS 工会会员, [1婚育证明].FName AS 婚育证明, [1人员性质].FName AS 人员性质, [1暂住证].FName AS 暂住证, dbo_t_Emp.FNote AS 备注, dbo_t_Emp.FModifyTime AS 修改日期, dbo_t_Emp.FDeleted AS 禁用, [1班组].FName AS 班组, Year(Now())-Year([出生日期]) AS 年龄, [1婚姻状况].FName AS 婚姻状况, dbo_t_Emp.F_107 AS 户口所在地, [1社会保险].保险险种, [1社会保险].社会保险 AS 保险卡卡号, [1准备退社日期].准备退社日期, [1准备退社日期].离职原因, [1离职日期].离职日期, [1离职日期].离职编号, [1更衣箱号].更衣箱号, [1离职日期].离职备注, Round((DateDiff("y",[入职日期],Now()))/365,2) AS 入社年数, [1入社前工龄].入社前工龄, [1退保险].退保险 INTO 员工
FROM ((((((((((((((((((dbo_t_Emp LEFT JOIN 1人事_学历 ON dbo_t_Emp.FDegree = [1人事_学历].FInterID) LEFT JOIN 1人事_职务 ON dbo_t_Emp.FDuty = [1人事_职务].FInterID) LEFT JOIN 1人事_性别 ON dbo_t_Emp.FGender = [1人事_性别].FInterID) LEFT JOIN 1人员属地 ON dbo_t_Emp.F_103 = [1人员属地].FItemID) LEFT JOIN 1用工形式 ON dbo_t_Emp.F_104 = [1用工形式].FItemID) LEFT JOIN 1工会会员 ON dbo_t_Emp.F_113 = [1工会会员].FItemID) LEFT JOIN 1婚育证明 ON dbo_t_Emp.F_115 = [1婚育证明].FItemID) LEFT JOIN 1人员性质 ON dbo_t_Emp.F_117 = [1人员性质].FItemID) LEFT JOIN 1暂住证 ON dbo_t_Emp.F_116 = [1暂住证].FItemID) LEFT JOIN 1部门 ON dbo_t_Emp.FDepartmentID = [1部门].FItemID) LEFT JOIN 1人事_账号 ON dbo_t_Emp.FNumber = [1人事_账号].FNumber) LEFT JOIN 1班组 ON dbo_t_Emp.F_119 = [1班组].FItemID) LEFT JOIN 1社会保险 ON dbo_t_Emp.FNumber = [1社会保险].工号) LEFT JOIN 1婚姻状况 ON dbo_t_Emp.F_120 = [1婚姻状况].FItemID) LEFT JOIN 1准备退社日期 ON dbo_t_Emp.FNumber = [1准备退社日期].工号) LEFT JOIN 1离职日期 ON dbo_t_Emp.FNumber = [1离职日期].工号) LEFT JOIN 1入社前工龄 ON dbo_t_Emp.FNumber = [1入社前工龄].工号) LEFT JOIN 1退保险 ON dbo_t_Emp.FNumber = [1退保险].工号) LEFT JOIN 1更衣箱号 ON dbo_t_Emp.FNumber = [1更衣箱号].工号
WHERE (((dbo_t_Emp.FName)<>"morningstar" And (dbo_t_Emp.FName)<>"administrator") AND ((dbo_t_Emp.FDeleted)=0));
恐怖
老汉版主,帮个忙哈
因为很多数据是从不同地方输入不同表中,所以我这里汇总以后就有了这个生成表,关于前面为什么要不同地方输入不同表中我无力改变,敬请帮忙!
为什么不先做联合查询或者其它查询,然后再以这些查询做查询呢?现在我的眼睛看得骨折了~~
总记录:5篇 页次:1/1 9 1 :