SELECT s.skuid, n.linkid FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_PRD_Nutrition n ON (s.skuid = n.linkid AND n.nutType = 'SKU') WHERE s.sku = INSERT INTO tbl_PRD_Nutrition(Ownerid, fsl_tableCode, nutType, linkid, weightSrvGrams, UnitDescription, Calories, Fat_Cal, Fat, Transfat, SaturatedFat, Cholesterol, Sodium, Carbs, Fiber, Sugar, Protein, VitaminA, VitaminA_Type, VitaminC, Calcium, Iron) VALUES (110, 'MFR', 'SKU', #chkNut.skuid#, '#getData.ServingSize#', 'g', #val(getData.Calories)#, #val(getData.CaloriesFromFat)#, #val(getData.TotalFat)#, #val(getData.Transfat)#, #val(getData.SaturatedFat)#, #val(getData.Cholesterol)#, #val(getData.Sodium)#, #val(getData.Carbs)#, #val(getData.Fiber)#, #val(getData.Sugars)#, #val(getData.Protein)#, #val(getData.VitaminA)#, '%', #val(getData.VitaminC)#, #val(getData.Calcium)#, #val(getData.Iron)#) UPDATE tbl_PRD_Nutrition SET weightSrvGrams = , UnitDescription = 'g', Calories = , Fat_Cal = , Fat = , SaturatedFat = , Transfat = , Cholesterol = , Sodium = , Carbs = , Fiber = , Sugar = , Protein = , VitaminA = , VitaminA_type = '%', VitaminC = , Calcium = , Iron = WHERE Ownerid = 110 AND fsl_tableCode = 'MFR' AND nutType = 'SKU' AND linkid = #chkNut.linkid# --->