28,409
社区成员




SELECT a.姓名,c.籍贯 from (a as a left join b as b on (a.姓名=b.姓名 and a.工作日期<#2021-1-1#)) left join c as c on c.姓名=a.姓名 where b.id is null
select a.姓名, c.籍贯 from 表a a
left join 表b b on b.姓名=a.姓名
left join 表c c on c.姓名=a.姓名
where a.工作日期>'2021/1/1' and b.id is null
select a.姓名 from a left join b on b.姓名=a.姓名 where a.工作日期>'2021/1/1' and b.id is null
select a.姓名 from a left join b on b.name=a.name where b.id is null