select *
from t
where checksum(id1,id2,name)
not in(select check(id1,id2,name) from t where date='2日')
and date='1日'
from t
where checksum(id1,id2,name)
not in(select check(id1,id2,name) from t where date='2日')
and date='1日'
from t
where checksum(id1,id2,name)
not in(select check(id1,id2,name) from t where date='2日')
and date='1日'
select * from
(select * from 表 where date='1日') a
where not exists (
select * from 表 where date='2日' and ID1=a.ID1 and ID2=a.ID2 and NAME=a.NAME
)