SELECT sku, skudesc, p.upc, p.scc14 FROM tbl_PRD_Skus s LEFT OUTER JOIN tbl_PRD_Packaging p ON (s.skuid = p.linkid and p.linkType = 'SKU') WHERE s.OwnerID = 457 AND s.FSL_TableCode = 'MFR' AND s.inactive = 0 AND s.skudesc NOT Like '%UNKNOWN%' AND COALESCE(s.privateLabelType,'') = CASE WHEN 457 = 457 THEN '' END ORDER BY Sku
SKU SKU DESC UPC UPC STATUS SCC14 SCC14 STATUS
'#qry_GetData.sku# #qry_GetData.skudesc# class="noticeMeTxt" >'#upc_clean#  class="noticeMeTxt" >#CheckBitValidator(upc_clean)# class="noticeMeTxt" >'#SCC14_clean#  class="noticeMeTxt" >#CheckBitValidator(SCC14_clean)#