INSERT INTO stock
SELECT
Z.ITEM_CODE,
SUBSTRING( Z.YYMMDD, 1, 7 ) AS DD,
SUM( Z.B_COUNT ) AS BQ,
SUM( Z.I_COUNT ) AS IQ,
SUM( Z.O_COUNT ) AS OQ,
SUM( Z.I_COUNT ) - SUM( Z.O_COUNT ) AS MQ,
SUM( Z.B_COUNT ) + SUM( Z.I_COUNT ) - SUM( Z.O_COUNT ) AS JQ
FROM (
SELECT
p_code AS ITEM_CODE,
f_period AS YYMMDD,
0 AS B_COUNT,
SUM( p_num ) AS I_COUNT,
0 AS O_COUNT
FROM stock_ipgo_2
WHERE f_period = '20081011'
GROUP BY f_period, p_code
UNION ALL
SELECT
p_code AS ITEM_CODE,
f_period AS YYMMDD,
0 AS B_COUNT,
0 AS I_COUNT,
SUM( p_num ) AS O_COUNT
FROM stock_sell_2
WHERE f_period = '20081011'
GROUP BY f_period, p_code
)Z
GROUP BY SUBSTRING( Z.YYMMDD, 1, 7 ) , Z.ITEM_CODE
===========================================================
#1136 - Row 1에서 칼럼 카운트와 value 카운터와 일치하지 않습니다.
=============================================================
칼럼을 정확히 맞추었는데. 이런 에러가 나는 이유가 뭔지...
mysql 버전이 올라감에 따라 칼럼수도 틀려졌다고 하는데..
뭔말인지요?
현재 버전이
5.0.51a-community-nt
입니다. |