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)#