从员工表中选择员工的Quary，但不在考勤表中 [英] Quary for select Employee from employee table but not in attendance table

问题描述

Hai专家请帮助我，





我有两张桌子，一个是员工主持人和一个出勤人员_b。







我想选择EmployeeMaster中的所有员工，但不选择Attendence_Tb

Hai Experts please Help me,


I have two table, An EmployeeMaster and An Attendance_Tb.



I want to select all employees in EmployeeMaster but not in Attendence_Tb

推荐答案

select * from EmployeeMaster
where employee_id not in (
    select employee_id from Attendance_Tb
)

这篇关于从员工表中选择员工的Quary，但不在考勤表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！