txjb.sql

人事管理源码 Delphi+ADO+Acce

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

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