zzquy2.sql

来自「人事管理系统 人事管理系统」· SQL 代码 · 共 15 行

use rsgl
go

select main.main_id,isnull(main.name,''),isnull(main.sex,''),isnull(main.mz,''),isnull(main.born,''),
       isnull(main.jobdate,0),isnull(main.cgdate,0),isnull(main.hunyin,''),isnull(main.dw_id,''),isnull(dw.bm,''),
       isnull(dw.dw,''),isnull(main.gw,''),isnull(main.xueli,''),isnull(main.zc,''),isnull(main.zm,''),
       isnull(main.zm_date,0),isnull(main.LianXi,''),isnull(main.address,''),isnull(main.idcard,''),
       isnull(main.dangan,''),isnull(main.diannao,''),isnull(main.yiliaocard,''),isnull(main.yibaocard,''),
       isnull(main.jl,''),isnull(main.jnpay,0),isnull(main.gw94,0),isnull(main.gw96,0),isnull(main.gw2003,0),
       isnull(main.gsbt,0),isnull(main.jtqk,''),isnull(main.worklb,''),isnull(main.yonggong,''),isnull(main.zt,'zz')
from main,dw
where (main.dw_id=dw.dw_id) and main.zt='zz'
order by main.dw_id