Re: MERGE - INSERT/UPDATE

Hi,Thanks for your response again.
I really appreciate.
You are right.
i need to really check the all three tables data. But I confused with the data earlier I mentioned. _ext and upload are the same tables.
7)select count(sku_id) from SKU_ATTR where sku_id not in (select sku_id from sku) -- 0-- which one need to consider for error? select count(sku_id) from SKU_ATTR where sku_id not in (select sku_id from sku_ext) -- 179-- this is same as upload table

12)select count(*) from sku_ext where sku_id not in (select sku_id from sku_attr_ext)-- 0 Records --

Thanks,

-- 
Message posted via http://www.dbmonster.com