查询INVLA有值但INVLH无信息(成本要素档没有回写)-李丹

--查询INVLA有值但INVLH无信息（成本要素档没有回写）
SELECT LA001,LA004,LA005,LA006,LA007,LA008,LA009,LA010,LA011,LA012,LA013,LA014,
LA015,LA016,LA017,LA018,LA019,LA020,LA023

FROM INVLA

WHERE LA006+LA007+LA008 NOT IN (SELECT LH002+LH003+LH004 FROM INVLH WHERE LH001='201406')
AND LA004>='20140601' AND LA004<='20140630' ----算完高级成本

--查询金额不相等
SELECT LA006,LA007,LA008,LA005,LA001,LA004,LA013,LH002,LH003,LH004,LH008B
FROM INVLA
LEFT JOIN (SELECT LH002,LH003,LH004,LH005,SUM(LH008)AS LH008B
FROM INVLH
WHERE LH001='201406'
GROUP BY LH002,LH003,LH004,LH005
) AS SJL ON LA006=LH002 AND LA007=LH003 AND LA008=LH004 AND LA005=LH005
WHERE LA004>='20140601' AND LA004<='20140630' AND LA013<>LH008B
ORDER BY LA006,LA007,LA008 ----算完高级成本

--查询月档单头跟月档要素档的起初金额不相等
SELECT LB001 AS 品号,LB002 as 年月,LB004 AS 月档金额,LJ001 AS 要素品号,LJ002 AS 要素年月 ,
LJ004B AS 要素总金额 ,(LB004-LJ004B ) AS 差额
FROM INVLB
LEFT JOIN
(SELECT LJ001,LJ002,SUM(LJ004) AS LJ004B
FROM INVLJ
WHERE LJ002='201401'
GROUP BY LJ001,LJ002
) AS SJL ON LB001=LJ001 AND LB002=LJ002
WHERE LB002='201401'
-- AND LA013<>LH008B
ORDER BY LB001,LB002,LB004,LJ001,LJ002,LJ004B


----算完高级成本