Re: MERGE - INSERT/UPDATE

The way I look at it, your # 7 is backward ... I would think you would want to produce
Select count(sku_id) from sku_ext ... with one of the following 1- where sku_id not in (select sku_id from sku); -- value not in parent table
 or
2- where sku_id not in (select sku_id from sku_attr); -- value not in existing table
Implying that you are looking in the new table, for values that do not exist in your old table(s) Received on Thu May 05 2005 - 16:02:01 CDT