Code:
INSERT INTO [MADE XYZ_PRCNG1]
(
A_FIELD_NUM,
A_FIELD_TY_CD,
RSN_CD,
A_FIELD_PRC_EFF_DT,
A_FIELD_PRC_END_DT,
A_FIELD_PRC_AMT,
CURR_ROW_IND,
PRCNG_SRC_CD
)
SELECT XYZ_PRCNG_H.A_FIELD_NUM,
XYZ_PRCNG_H.A_FIELD_TY_CD,
XYZ_PRCNG_H.RSN_CD,
XYZ_PRCNG_H.A_FIELD_PRC_EFF_DT,
XYZ_PRCNG_H.A_FIELD_PRC_END_DT,
XYZ_PRCNG_H.A_FIELD_PRC_AMT,
XYZ_PRCNG_H.CURR_ROW_IND,
XYZ_PRCNG_H.PRCNG_SRC_CD
FROM XYZ_PRCNG_H
INNER JOIN [MADE Distinct A_FIELDs]
ON XYZ_PRCNG_H.A_FIELD_NUM = [MADE Distinct A_FIELDs].[A_FIELD Code]
WHERE (((
XYZ_PRCNG_H.A_FIELD_TY_CD)="01")
AND ((
XYZ_PRCNG_H.RSN_CD)<>"04")));
Ok so what I understand is that we are doing a INSERT ONTO the MADE XYZ_PRCNG1 TABLE. We are going to be INSERTING ONTO the 8