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
200字范文,内容丰富有趣,生活中的好帮手!
时间:2019-03-03 16:28:41
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