员工信息表[员工号,姓名,性别],T_Worker[WorkerId,name,sex]
员工迟到表[员工号,迟到日期,迟到时长],T_Late[WorkerId,latetime,latelong]
问:没有迟到的员工信息(用Join)
员工迟到表[员工号,迟到日期,迟到时长],T_Late[WorkerId,latetime,latelong]
问:没有迟到的员工信息(用Join)
select * from (select a.*,b.latetime from T_Worker a left join T_Late b on a.WorkerId=b.WorkerId) a where latetime is null
--员工信息表[员工号,姓名,性别,
create table T_Worker
(
WorkerId varchar(50),
name varchar(50),
sex char(20)
)
--员工迟到表[员工号,迟到日期,迟到时长,
create table T_Late
(
WorkerId varchar(25),
latetime datetime,
latelong time
)insert into T_Worker
select '001','张家玮','男' union all
select '002','李秀林','女' union all
select '003','谭韦伯','男' union all
select '004','灵儿','女' insert into T_Late
select '001',GETDATE(),'00:30:00' union all
select '003',GETDATE(),'00:10:00'select * from T_Worker
where WorkerId not in(
select TL.WorkerId
from T_Late TL
inner join T_Worker TW
on TL.WorkerId=TW.WorkerId
)
结果如图:
select t0.* from T_Worker t0 left join T_Late t1
on t0.WorkerId=t1.WorkerId
where t1.WorkerId is null and t1.latetime is null