Sql compare tables and insert missing data

[o23450]

Compare Tables ITEM_A/I_ID with ITEM/I_ID, filtering so that you are only addressing item IDs that start with 25*. Make a list of ITEM lines that ARE NOT in ITEM_A

From that list, create new rows in ITEM_A inserting the following fields
ITEM ITEM_A
a. I_ID I_ID
b. ITEM_R_ID ITEM_R_ID
c. ITEM_DESC SALES_DESC

[PAVB]

Homework, huh?

Okay ... there are a lot of unknowns in those business specs - like datatypes, complete table structures, etc - so, here you have a template - after all, your instructor really wants you to do at least part of it, isn't it?

insert
into    
    item_a
select  
    *
from
(
    select  *
    from    item
    where   i_id like '25%'
    minus
    select  *
    from    item_a
    where   i_id like '25%'
);