SELECT [型号表].[型号],
ISNULL(SUM([领料表].[领用个数]),0) AS [共领料],
ISNULL(SUM([入库表].[入库数量]),0) AS [共入库]
FROM [型号表]
LEFT JOIN [领料表] ON [型号表].[型号] = [领料表].[型号]
LEFT JOIN [入库表] ON [型号表].[型号] = [入库表].[型号]
GROUP BY [型号表].[型号] 以上正解。多余的话,还可以加ORDER BY [型号表].[型号]。用LEFT JOIN 方式好像不方便用简名的。
ISNULL(SUM([领料表].[领用个数]),0) AS [共领料],
ISNULL(SUM([入库表].[入库数量]),0) AS [共入库]
FROM [型号表]
LEFT JOIN [领料表] ON [型号表].[型号] = [领料表].[型号]
LEFT JOIN [入库表] ON [型号表].[型号] = [入库表].[型号]
GROUP BY [型号表].[型号] 以上正解。多余的话,还可以加ORDER BY [型号表].[型号]。用LEFT JOIN 方式好像不方便用简名的。