多表联查

1 SELECT
 2   A.型号,
 3   NVL(B.领用个数SUM,0) AS 共领料,
 4   NVL(C.入库数量SUM,0) AS 共入库,
 5 FROM 型号表 A
 6 LEFT JOIN (
 7   SELECT SUBB.型号,SUM(SUBB.领用个数) AS 领用个数SUM
 8   FROM 领料表 SUBB
 9   GROUP BY 型号
10 ) B
11 ON B.型号 = A.型号
12 LEFT JOIN (
13   SELECT SUBC.型号,SUM(SUBC.入库数量) AS 入库数量SUM
14   FROM 入库表 SUBC
15   GROUP BY 型号
16 ) C
17 ON C.型号 = A.型号
18 ORDER BY A.型号 ASC