access关联两个字段 – 数据库 – 前端

select name,a.no,score from table1 a, table2 b where a.no=b.no and a..score=b.score select name,no,score from table1 where no not in (select no from table2 ) and score is null