34,588
社区成员
发帖
与我相关
我的任务
分享
select *
from att_idcard a
where a.in_out='E'
and input_time>='2008-01-17'
and input_time<'2008-01-18'
and not exists (
select 1
from emp_master b
where b.id_card=a.card_id
and b.status in ('P','W')
)
--or :
select a.*
from att_idcard a left join emp_master b
on b.id_card=a.card_id
and b.status in ('P','W')
where b.id_card is null
and a.in_out='E'
and input_time>='2008-01-17'
and input_time<'2008-01-18'