两个表有一个字段相同怎么做连接？

1，SELECt NAME,convert(int,@sum)-COUNT(name) from myfn_filtercard2(@tmpstart,@tmpend,@brchname)
GROUP BY NAME
ORDER BY NAME
2，SELECt name,SUM(times) FROM
HWATT..offsubmit GROUP BY NAME ORDER BY NAME
name字段相同 怎么做连接？

SELECt A.*,B.* FROM

(SELECt NAME,convert(int,@sum)-COUNT(name) from myfn_filtercard2(@tmpstart,@tmpend,@brchname)
GROUP BY NAME) A,

(SELECt name,SUM(times) FROM
HWATT..offsubmit GROUP BY NAME ORDER BY NAME) B

WHERe A.NAME = B.NAME(+)

所以查询出来的记录，设计视图， 将两个表添加进查询源中，将要查找相同值的字段从一个表中拖到另一个表中在access数据库查询窗口中，新建查询：因为建立一对一关系， 此时表间会有一条线连接两个表，此时便建立了表间一对一关系。 最后将查询所需要的字段拖入字段列中。 说明

WITH AA AS ( SELECt NAME,convert(int,@sum)-COUNT(name) from myfn_filtercard2(@tmpstart,@tmpend,@brchname) GROUP BY NAME) ,BB AS ( SELECt name,SUM(times) FROM HWATT..offsubmit GROUP BY NAME ) SELECt * FROM AA JOIN BB ON AA.NAME=BB.NAME