access關聯(lián)兩個字段？

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