INSERT INTO tbl_PRD_Allergens(prdCode, prdId, prdLevel, OwnerId, FSL_TableCode, eggs, fish ,milk ,peanuts, shellfish, soybeans, treenuts, wheat) SELECT p.sku_sku, p.sku_skuid, '#attributes.catalogLevel#', #attributes.ownerid#, '#attributes.ownerType#', '0', '0', '0', '0', '0', '0', '0', '0' FROM tbl_IMPORT_Productdata p LEFT OUTER JOIN tbl_PRD_Allergens a ON (a.prdCode = p.sku_sku AND a.ownerid = AND a.fsl_tableCode = AND a.prdLevel = ) WHERE eai_batchid = AND a.prdCode IS NULL AND p.sku_skuid IS NOT NULL; SET ANSI_WARNINGS OFF UPDATE a SET LevelofContainment_carrots = alg_LevelofContainment_carrots, carrots = alg_carrots, LevelofContainment_celery = alg_LevelofContainment_celery, celery = alg_celery, LevelofContainment_glutenCereals = alg_LevelofContainment_glutenCereals, glutenCereals = alg_glutenCereals, LevelofContainment_cocoa = alg_LevelofContainment_cocoa, cocoa = alg_cocoa, LevelofContainment_coriander = alg_LevelofContainment_coriander, coriander = alg_coriander, LevelofContainment_corn = alg_LevelofContainment_corn, corn = alg_corn, LevelofContainment_eggs = alg_LevelofContainment_eggs, eggs = alg_eggs, LevelofContainment_fish = alg_LevelofContainment_fish, fish = alg_fish, LevelofContainment_lupine = alg_LevelofContainment_lupine, lupine = alg_lupine, LevelofContainment_milk = alg_LevelofContainment_milk, milk = alg_milk, LevelofContainment_molluscs = alg_LevelofContainment_molluscs, molluscs = alg_molluscs, LevelofContainment_mustard = alg_LevelofContainment_mustard, mustard = alg_mustard, LevelofContainment_peanuts = alg_LevelofContainment_peanuts, peanuts = alg_peanuts, LevelofContainment_podFruits = alg_LevelofContainment_podFruits, podFruits = alg_podFruits, LevelofContainment_rye = alg_LevelofContainment_rye, rye = alg_rye, LevelofContainment_sesameSeeds = alg_LevelofContainment_sesameSeeds, sesameSeeds = alg_sesameSeeds, LevelofContainment_shellfish = alg_LevelofContainment_shellfish, shellfish = alg_shellfish, LevelofContainment_soybeans = alg_LevelofContainment_soybeans, soybeans = alg_soybeans, LevelofContainment_sulphites = alg_LevelofContainment_sulphites, sulphites = alg_sulphites, LevelofContainment_treenuts = alg_LevelofContainment_treenuts, treenuts = alg_treenuts, LevelofContainment_wheat = alg_LevelofContainment_wheat, wheat = alg_wheat, FALCPA = alg_FALCPA FROM tbl_PRD_Allergens a INNER JOIN tbl_IMPORT_ProductData p ON (a.prdid = p.sku_skuid) WHERE p.eai_batchid = AND a.OwnerID = AND a.FSL_TableCode = AND a.prdLevel = AND p.sku_skuid IS NOT NULL;