ntjb.sql

人事管理源码 Delphi+ADO+Acce

select main.dw_id,main.name,main.sex,main.born,main.jobdate,
main.gw,main.xueli,main.jnpay,main.gw2003,main.dangan,
main.yibaocard,main.yiliaocard,main.idcard,main.tolpay,
dw.bm,dw.dw

from main,dw
where (main.dw_id=dw.dw_id) and (main.zt='NT')
order by main.dw_id