select s.ownerId, s.fsl_tablecode, s.skuId, s.sku, s.skuDesc, m.mfr_name from tbl_PRD_Packaging p with (nolock) inner join tbl_PRD_Skus s with (nolock) on s.skuId = p.linkId and s.ownerId = and s.fsl_tablecode = inner join tblManufacturers m with (nolock) on m.mfr_id = s.mfrId where p.linkType = 'SKU' and ( 1 = 2 or p.UPC = or p.scc14 = ) order by s.skuId insert into tbl_OPR_UPCscans (ownerid, ownertype, partnerid, partnertype, UPC, manufacturer, description ) values ( , , , , , , )