SELECT 入库明细.物件编号, 入库明细.入库数量, 出库明细.出库数量, (Sum(入库明细.入库数量)-Sum(出库明细.出库数量)) AS 库存 FROM 出库明细 INNER JOIN 入库明细 ON 入库明细.物件编号=出库明细.物件编号 GROUP BY 入库明细.物件编号, 入库明细.入库数量, 出库明细.出库数量; 得到的库存1003万用表和1005没有,我要把他们也显示出来,问题在哪
?
è¿æ ·è¯è¯
追é®è¿æ¯ä¸è¡ï¼é®é¢å¨åªï¼æææ件åç»ä½
SELECT ããçç¥ ãã (Sum(å
¥åºæç».å
¥åºæ°é)-Sum(SWITCH(åºåºæç».åºåºæ°é IS NULL,0,TRUE,åºåºæç».åºåºæ°é))) AS åºå
FROM åºåºæç» LEFT JOIN å
¥åºæç» ON å
¥åºæç».ç©ä»¶ç¼å·=åºåºæç».ç©ä»¶ç¼å·
GROUP BY å
¥åºæç».ç©ä»¶ç¼å·, å
¥åºæç».å
¥åºæ°é, åºåºæç».åºåºæ°é;
æä½ ï¼æ¥æ¶ä¸ï¼æµè§å¨å³ä¸è§