jsjb.sql

人事管理源码 Delphi+ADO+Acce

select main.dw_id,main.name,main.sex,main.born,
main.dangan,main.idcard,main.txdate,main.tingxindate,
main.jswhy,dw.bm

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