SELECT A1.SDATE,A1.AMT01,A2.AMT02
FROM
(
SELECT S1.SDATE,SUM(S1.AMT) AS AMT01
FROM PACKLIB.SALE S1
WHERE S1.CUS ='00020'
AND S1.PKIND1 ='1'
AND S1.FAC ='01'
AND S1.SDATE ='20080107'
GROUP BY S1.SDATE
) A1
full outer join
(
SELECT S2.SDATE,SUM(S2.AMT) AS AMT02-
FROM PACKLIB.SALE S2
WHERE S2.CUS ='00020'
AND S2.PKIND1 ='1'
AND S2.FAC ='02'
AND S2.SDATE ='20080107'
GROUP BY S2.SDATE
)A2
on A1.SDATE = A2.SDATE
-------------------------------------------------------------------------------
에러 column qualifier or table A2 underfined (state:S1000, Native Code : FFFFEC77)
뭐가 문제죠?...
조언 좀 부탁해요
|