标题: 有两张表1,表2,需要依员工编号做外联接,请教! [打印本页] 作者: mimihu 时间: 2005-9-2 06:11 标题: 有两张表1,表2,需要依员工编号做外联接,请教! DoCmd.RunSQL ("SELECT a.qzh, a.mlh, a.ajh, b.wjfs as 案卷级卷内份数, a.卷内份数 as 文件级卷内份数 into 表3 FROM 表1 AS a FULL OUTER JOIN 表2 AS b ON (a.qzh=b.qzh) AND (a.mlh=b.mlh) AND (a.ajh=b.ajh) WHERE a.卷内份数<>b.wjfs ")