参考USE [lis]goSELECT 批号=b.批号, 品名=a3.品名, 数量=SUM(a2.数量) INTO dbo.B2 FROM OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A2 a2 JOIN OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A1 a1 ON a2.出库号=a1.单据号 JOIN OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A3 a3 ON a2.内部编号=a3.内部编号 JOIN B1 b1 ON a1.流水号=b1.流水号 GROUP BY b.批号,a3.品名
品名=a3.品名,
数量=SUM(a2.数量)
INTO dbo.B2
FROM OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A2 a2 JOIN
OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A1 a1
ON a2.出库号=a1.单据号 JOIN OPENDATASOURCE('SQLOLEDB','Data Source=主机SHJ的IP;User ID=sa;Password=123').anydata.dbo.A3 a3
ON a2.内部编号=a3.内部编号 JOIN B1 b1 ON a1.流水号=b1.流水号
GROUP BY b.批号,a3.品名
搞清楚两个表之间怎么连接就可以了