📄 zzquy2.sql
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -