SELECT prd.product, prd.shortdesc, s.skuid, s.sku, s.skudesc, m.mfr_name , s.sku sku_sku, s.skudesc sku_skudesc FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_PRD_Products prd ON (s.prodid = prd.prodid) LEFT OUTER JOIN tblManufacturers m ON (s.mfrid = m.mfr_id) LEFT OUTER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid AND p.eai_batchid = WHERE s.ownerid = AND s.fsl_tableCode = AND s.inactive = 0 AND nullif(p.sku_sku,'') IS NULL UPDATE s SET s.inactive = 1, s.OwnerID = s.OwnerID *-1, s.FSL_TableCode = Left(s.FSL_TableCode,2) + 'X', s.inActiveDate = getdate() FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid AND p.eai_batchid = WHERE s.ownerid = AND s.fsl_tableCode = AND s.inactive = 0 AND nullif(p.sku_sku,'') IS NULL ---> SELECT s.SkuID, s.ownerid, s.fsl_tableCode FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_IMPORT_ProductData p ON s.sku = p.sku_sku AND s.mfrid = p.sku_mfrid AND p.eai_batchid = WHERE s.ownerid = AND s.fsl_tableCode = AND s.inactive = 0 AND nullif(p.sku_sku,'') IS NULL update tbl_PRD_Skus set CRMActive = 'N', unpublishDate = getDate(), CRMOverride = 'Y' where fsl_tableCode = and ownerid = and skuid =