Help Understanding what this Query is doing [INSERT INTO, SELECT , FROM, INNER JOIN, ON, WHERE]

[Noob]

Hi Everybody,



I dont understand this Query fully & was hoping someone would be kind &help me get my brain wrapped around what is going on.

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 like FIELDs. Thats all I got. The SELECT FROM INNER JOIN part is throwing me for a loop. Is that a 9th FIELD that is going to be INSERTED INTO?

[ranman256]

the INSERT query adds records to a table.
THIS query is using another query to add the records.
The 2nd query joins 2 tables together.

[Noob]

Wow I didnt know that could be done all in 1 SQL statement. Thanks a lot @ranman256. This seems way more advanced than whats covered in any of the learning materials I have got my hands on. If anyone knows of a book that covers advanced SQL queries PLEASE mention it. Thanks in advance.

[Noob]

I found this: Subquery Fundamentals