INSERT INTO tbl_PRD_NutritionalClaims(ownerID, fsl_TableCode, prdCode, prdLevel, prdid) SELECT #attributes.ownerid#, '#attributes.ownerType#', p.sku_sku, '#attributes.catalogLevel#', p.sku_skuid FROM tbl_IMPORT_Productdata p LEFT OUTER JOIN tbl_PRD_NutritionalClaims n ON (n.prdID = p.sku_skuid AND n.ownerid = AND n.fsl_tableCode = AND n.prdLevel = ) WHERE eai_batchid = AND n.prdid IS NULL AND p.sku_sku IS NOT NULL UPDATE claims SET LowCalorie = p.clm_LowCalorie, CalorieFree = p.clm_CalorieFree, CalorieFreeFood = p.clm_CalorieFreeFood, FatFree = p.clm_FatFree, FatFreeFood = p.clm_FatFreeFood, LowFat = p.clm_LowFat, LowFatFood = p.clm_LowFatFood, SatFatFree = p.clm_SatFatFree, SatFatFreeFood = p.clm_SatFatFreeFood, LowSatFat = p.clm_LowSatFat, LowSatFatFood = p.clm_LowSatFatFood, CholesterolFree = p.clm_CholesterolFree, CholesterolFreeFood = p.clm_CholesterolFreeFood, LowCholesterol = p.clm_LowCholesterol, SodiumFree = p.clm_SodiumFree, VeryLowSodium = p.clm_VeryLowSodium, LowSodium = p.clm_LowSodium, reducedSodium = p.clm_reducedSodium, noSaltAdded = p.clm_noSaltAdded, SugarFree = p.clm_SugarFree, NoSugarAdded = p.clm_NoSugarAdded, HighFiber = p.clm_HighFiber, ExcellentSourceFiber = p.clm_ExcellentSourceFiber, GoodSourceFiber = p.clm_GoodSourceFiber, LactoseFree = p.clm_LactoseFree, Healthy = p.clm_Healthy, GoodSourceProtein = p.clm_GoodSourceProtein, MadeWithWholeGrain = p.clm_MadeWithWholeGrain, noMSG = p.clm_noMSG, noAddedMSG = p.clm_noAddedMSG, noTransFat = p.clm_noTransFat, zeroTransFat = p.clm_zeroTransFat, glutenFree = p.clm_glutenFree, vegan = p.clm_vegan, vegetarian = p.clm_vegetarian, wholeGrain51Percent = p.clm_wholeGrain51Percent, smartSnack = p.clm_smartSnack, rBGHfree = p.clm_rBGHfree, antibioticFree = p.clm_antibioticFree FROM tbl_PRD_NutritionalClaims claims INNER JOIN tbl_IMPORT_ProductData p ON (claims.prdID = p.sku_skuid) WHERE p.eai_batchid = AND claims.OwnerID = AND claims.fsl_tableCode = AND claims.prdLevel = AND p.sku_sku IS NOT NULL AND coalesce(p.sku_processAction,'') <> 'INACTIVE'