Refectio

Report被要求修改
所以又得寫一支Query的語法
select id_no,emp_na,dispatchdate,dept_no,dept_na from token_asset as s
where not exists
(
select * from token_usage as h
where s.id_no=h.emp_id
)
and id_no <> 'Sysadmin' order by dept_no

另外語法的連結
http://rayting.pixnet.net/blog/post/21768123