tyjb.sql

来自「人事管理源码 Delphi+ADO+Acce」· SQL 代码 · 共 7 行

select main.dw_id,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

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