[求助]求一查询语句，在线等

liu_20012001

这样的查询该怎样写？例：

表1                               表2                                                 查询结果

姓名                              姓名              分数                              姓名                         分数

a                                     c                  100                                 a                               0

b                                                                                                 b                               0

c                                                                                                   c                             100

向您问好

这可能是分类汇兑的问题吧？如果是，用group by就行

sxycgxj

Select A.姓名,分数=isnull(分数,0) From  表1 A

  Left Join 表2 B ON A.姓名=B.姓名