Question

access 中，表table1和table2，table2是table1的真子集。我想查出属于table1中不属于table2的记录

Answer 1

select table1.* from table1 left join table2 on table1.FNkey = table2.FNkey where table2.FNkey is null
table1.FNkey和table2.FNkey分别是table1和table2的主键

Answer 2

1、前提条件：两表都设置主键，且字段相同；
2、select *
from table1
where table1.主键 not in(select table2.主键 from table2）